returning oid of last insert?
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:
Show quoted text
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)