Re: [GENERAL] OID Question

Поиск
Список
Период
Сортировка
От Geoffrey
Тема Re: [GENERAL] OID Question
Дата
Msg-id 4193CCC6.3080505@3times25.net
обсуждение исходный текст
Ответ на Re: [GENERAL] OID Question  (Bruno Wolff III <bruno@wolff.to>)
Ответы Re: [GENERAL] OID Question  (Bruno Wolff III <bruno@wolff.to>)
Re: [GENERAL] OID Question  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-novice
Bruno Wolff III wrote:
> On Thu, Nov 11, 2004 at 10:04:30 -0500, Terry Lee Tucker
> <terry@esc1.com> wrote:
>
>> Greetings,
>>
>> Here is a simple question:
>>
>> Is it ok to put a unique index on the oid for my tables? We are in
>> the process
>
>
> Yes, but you may occasionally have insert failures if the oid wraps
> around and you try to reuse one on an insert.

So this prompts a question regarding the documentation.  I'm assuming
that I can address the wrap-around issue based on the following found
under "Notes" section of the "Create Table" document:

"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?

--
Until later, Geoffrey

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: [GENERAL] OID Question
Следующее
От: "Kevin B."
Дата:
Сообщение: version changes