От: Michael Stone
Тема: insert without oids
Дата: ,
Msg-id: 20060113201011.GI1408@mathom.us
(см: обсуждение, исходный текст)
Ответы: Re: insert without oids  (Michael Fuhr)
Re: insert without oids  (Neil Conway)
Список: pgsql-performance

Скрыть дерево обсуждения

insert without oids  (Michael Stone, )
 Re: insert without oids  (Michael Fuhr, )
 Re: insert without oids  (Neil Conway, )
  Re: insert without oids  (Michael Stone, )

OIDs seem to be on their way out, and most of the time you can get a
more helpful result by using a serial primary key anyway, but I wonder
if there's any extension to INSERT to help identify what unique id a
newly-inserted key will get? Using OIDs the insert would return the OID
of the inserted row, which could be useful if you then want to refer to
that row in a subsequent operation. You could get the same result by
manually retrieving the next number in the sequence and using that value
in the insert, but at the cost of additional DB operations. Are there
plans on updating the insert API for the post-OID world?

Mike Stone


В списке pgsql-performance по дате сообщения:

От: "Jim C. Nasby"
Дата:
Сообщение: Re: Stable function being evaluated more than once in a single query
От: Bruce Momjian
Дата:
Сообщение: Re: Extremely irregular query performance