Re: OID wraparound (was Re: pg_depend)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: OID wraparound (was Re: pg_depend)
Дата
Msg-id 200107182106.f6IL6kj11504@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: OID wraparound (was Re: pg_depend)  ("Rod Taylor" <rbt@barchord.com>)
Список pgsql-hackers
> If OIDs are dropped a mechanism for retrieving the primary key of the
> last insert would be greatly appreciated.  Heck, it would be useful
> now (rather than returning OID).
> 
> I much prefer retrieving the sequence number after the insert than
> before insert where the insert uses it.  Especially when trigger
> muckary is involved.

Doesn't currval() work for your needs.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Mitch Vincent"
Дата:
Сообщение: Re: [HACKERS - GENERAL] PQexec() 8191 bytes limit and text fields
Следующее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: OID wraparound (was Re: pg_depend)