yes...had some problems with that, but with this parameter combination:

$self->db->dbh->last_insert_id(undef, undef, 'tablename', 'id_name');
[download]

SQLite, MySQL 4.0 and PostgreSQL 8.1 all pass my tests. I think SERIAL UNIQUE NOT NULL was also necessary for Pg, but not sure.