Re: [GENERAL] returning oid of last insert? - Mailing list pgsql-general

From Matt McClure
Subject Re: [GENERAL] returning oid of last insert?
Date
Msg-id Pine.GSO.3.94.980721122541.10191F-100000@mercury.cis.yale.edu
Whole thread Raw
In response to Re: [GENERAL] returning oid of last insert?  (Peter T Mount <peter@retep.org.uk>)
Responses Re: [GENERAL] returning oid of last insert?  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-general
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
>
>


pgsql-general by date:

Previous
From: Bruce Tong
Date:
Subject: Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]
Next
From: "Gene Selkov, Jr."
Date:
Subject: Re: [GENERAL] Postgres superuser priviledges