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
Re: [GENERAL] OID Question |
Список | 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 по дате отправления: