Re: [INIMSS] How to use OID?

Поиск
Список
Период
Сортировка
От Herbert Rabago Ambos
Тема Re: [INIMSS] How to use OID?
Дата
Msg-id Pine.LNX.4.33L2.0203141001230.7365-100000@hindang.msuiit.edu.ph
обсуждение исходный текст
Ответ на Re: [INIMSS] How to use OID?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-sql
> > Can I use it as a primary key?
>
> Yes, but I recommend against it, because OIDs are easily lost after a
> database restore...
>

i use OIDs to refer to unique records instead of using 3 or more composite
keys in the table for some processing.  ANd it's wise to index the oid
field also. But i dont use it as a primary key... as stated above.

-herbert



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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re:
Следующее
От: Bhuvan A
Дата:
Сообщение: checking for existence of a table in plpgsql.