Re: [GENERAL] OID Question

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: [GENERAL] OID Question
Дата
Msg-id 20041111210146.GA32254@wolff.to
обсуждение исходный текст
Ответ на Re: [GENERAL] OID Question  (Geoffrey <esoteric@3times25.net>)
Список pgsql-novice
On Thu, Nov 11, 2004 at 15:34:14 -0500,
  Geoffrey <esoteric@3times25.net> wrote:
>
> "Whenever an application makes use of OIDs to identify specific rows of
> a table, it is recommended to create a unique constraint on the oid
> column of that table, to ensure that OIDs in the table will indeed
> uniquely identify rows even after counter wraparound."
>
> Am I reading this correctly?  If I place a unique constraint on the oid
> column, I will not have to worry about oid wrap around?

No. The unique constraint may result in a transaction failing that
wouldn't otherwise fail and your application needs to be able to handle
this case.

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

Предыдущее
От: "Kevin B."
Дата:
Сообщение: version changes
Следующее
От: Geoffrey
Дата:
Сообщение: Re: version changes