DBIx::GeneratedKey

miyagawa on 2002-09-03T08:41:49

DBIx::GeneratedKey - DBD portable way to fetch last inserted object id. Difficult case is Pgsql, which has object id even if there's a primary key on tables. Furthermore, oid can be fetched via $sth, SERIAL can be from SQL, which is sucky I/F for me. link


something else to see

lachoy on 2002-09-03T11:36:43

I have this functionality working in SPOPS for sequences in Oracle and PostgreSQL; InterBase GENERATOR (almost exactly like a sequence); MySQL auto-increment; Sybase/MSSQL IDENTITY; SQLite inserted rowid. Fun!