are you doing this in psql?
Or perl, php, or some other?
perl and php both have methods for getting the oid of the last
inserted row (use "$oid = $sth->{'pg_oid_status'};"
in perl and "$oid = pg_GetLastOid($result_id);" in php )
Look at the php documentation, or do 'perldoc DBD::Pg'
to see mor
I use the following technique:
add sequence to the primary key of the table
look up the sequence the primary key
insert a record using (including) the primary key
re-query the newly inserted record using the primary key
Thanks, Michael
-Original Message-
From: David O'F
