in reply to Re^2: DBI insert: Need to retrieve an autoincremented column from a table after an insert.
in thread DBI insert: Need to retrieve an autoincremented column from a table after an insert.

I would want to keep the sequence ids in the database

I agree, its one of the warts from using a separate file. Like the OP, I've never completely trusted last_insert_id either, and getting unique row id's is just not an easy thing to do portably. I wasn't aware of DBIx::Sequence, just tried it out and it seems to work as advertized. Thanks for the pointer.

  • Comment on Re^3: DBI insert: Need to retrieve an autoincremented column from a table after an insert.

In Section Seekers of Perl Wisdom