OID and PK/FK KEYS

From: kilomegabyte(at)freemail(dot)it (Raffaele Spizzuoco)
To: pgsql-general(at)postgresql(dot)org
Subject: OID and PK/FK KEYS
Date: 2004-10-19 14:54:36
Message-ID: 5e42faf1.0410190654.69b7049a@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I'm from Italy, and sorry about my english...
I have a question that I know it is already said in the groups but I
have however some doubts
I have seen it is technically possible to use OID as PRIMARY KEY and
as FOREIGN KEY but it is correct to do so for the database's logical
integrity?
Is it better I use in any case other keys and not oid to avoid the
possible wraparound? or the wraparound is an extreme case and so I can
use quietly OID as PRIMARY and FOREIGN KEY?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hicham G. Elmongui 2004-10-19 14:56:44 code in docs gives me an error
Previous Message Andrew Sullivan 2004-10-19 14:43:22 Re: clustering