Getting OID in psql of recent insert

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Getting OID in psql of recent insert
Дата
Msg-id 199911190112.UAA20026@candle.pha.pa.us
обсуждение исходный текст
Ответы Re: [HACKERS] Getting OID in psql of recent insert  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
In writing the book, I see the serious limitation that there is no way
in psql to access the most recently inserted oid.  Without it, there
seems to be no way to use the oid value as a foreign key in another
table.

Should I add a function to return the most recently assigned oid to the
backend, or is there a better way?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@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 по дате отправления:

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: Hash Join is very slooow in some cases
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] psql & regress tests