Re: [GENERAL] returning oid of last insert?

Поиск
Список
Период
Сортировка
От Matt McClure
Тема Re: [GENERAL] returning oid of last insert?
Дата
Msg-id Pine.GSO.3.94.980721122541.10191F-100000@mercury.cis.yale.edu
обсуждение исходный текст
Ответ на Re: [GENERAL] returning oid of last insert?  (Peter T Mount <peter@retep.org.uk>)
Ответы Re: [GENERAL] returning oid of last insert?  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Tong
Дата:
Сообщение: Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]
Следующее
От: "Gene Selkov, Jr."
Дата:
Сообщение: Re: [GENERAL] Postgres superuser priviledges