Postgres Pro
Downloads
Home   >   mailing lists

Re: [INIMSS] How to use OID? - Mailing list pgsql-sql

From Herbert Rabago Ambos
Subject Re: [INIMSS] How to use OID?
Date
Msg-id Pine.LNX.4.33L2.0203141001230.7365-100000@hindang.msuiit.edu.ph
Whole thread Raw
In response to Re: [INIMSS] How to use OID?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-sql
Tree view 
> > 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 by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re:
Next
From: Bhuvan A
Date:
Subject: checking for existence of a table in plpgsql.