Re: [INIMSS] How to use OID?

From: Herbert Rabago Ambos <herbert(at)hindang(dot)msuiit(dot)edu(dot)ph>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [INIMSS] How to use OID?
Date: 2002-03-14 02:09:32
Message-ID: Pine.LNX.4.33L2.0203141001230.7365-100000@hindang.msuiit.edu.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-03-14 02:16:31 Re: Strange Postgresql Indexing Behavior
Previous Message Christopher Kings-Lynne 2002-03-14 01:29:27 Re: [INIMSS] How to use OID?