Thread: returning oid of last insert?
Is there a way to return the oid of the last insert command? Thanks, Matt
On Sat, 18 Jul 1998, Matt McClure wrote: > Is there a way to return the oid of the last insert command? The protocol does return the oid, as a string. You can see this when using psql. I'm not sure what libpq function returns this value though. In JDBC, there isn't an official way, but the 6.4 driver does have a method to retrieve the oid (It's used internally with the new object serialization code). Earler versions store the string, but don't use it, and have no method to retrieve it. -- Peter T Mount peter@retep.org.uk or petermount@earthling.net Main Homepage: http://www.retep.org.uk ************ Someday I may rebuild this signature completely ;-) ************ Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk
Thanks for the help. I checked libpq, and just to follow up, it is quite easy to get the oid of the last insert using the routine oidStatus. On Sun, 19 Jul 1998, Peter T Mount wrote: > On Sat, 18 Jul 1998, Matt McClure wrote: > > > Is there a way to return the oid of the last insert command? > > The protocol does return the oid, as a string. You can see this when using > psql. I'm not sure what libpq function returns this value though. > > In JDBC, there isn't an official way, but the 6.4 driver does have a > method to retrieve the oid (It's used internally with the new object > serialization code). Earler versions store the string, but don't use it, > and have no method to retrieve it. > > > -- > Peter T Mount peter@retep.org.uk or petermount@earthling.net > Main Homepage: http://www.retep.org.uk > ************ Someday I may rebuild this signature completely ;-) ************ > Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk > >
> Thanks for the help. I checked libpq, and just to follow up, it is quite > easy to get the oid of the last insert using the routine oidStatus. > > On Sun, 19 Jul 1998, Peter T Mount wrote: > > > On Sat, 18 Jul 1998, Matt McClure wrote: > > > > > Is there a way to return the oid of the last insert command? > > > > The protocol does return the oid, as a string. You can see this when using > > psql. I'm not sure what libpq function returns this value though. > > > > In JDBC, there isn't an official way, but the 6.4 driver does have a > > method to retrieve the oid (It's used internally with the new object > > serialization code). Earler versions store the string, but don't use it, > > and have no method to retrieve it. I have added this to the TODO list: * add a function to return the last inserted oid, for use in psql scripts We need it for psql scripts. Things using libpq directly already have access to this information. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)