using OID as primary key - Mailing list pgsql-sql

From Markus Wagner
Subject using OID as primary key
Date
Msg-id 3978385E.2182D8B4@imsd.uni-mainz.de
Whole thread Raw
Responses Re: using OID as primary key  (JanWieck@t-online.de (Jan Wieck))
List pgsql-sql
Hi,

are there any disadvantages of using OID as the primary key for any
table?
What about referencing external tuples using their OIDs?

e. g.:
CREATE TABLE thistable
...
field NUMERIC REFERENCES OtherTable (oid)

Which data type should I use to reference OIDs?

Will I run into problems later if I do my things this way?

Thanks,

Markus



pgsql-sql by date:

Previous
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: Re: [BUGS] problem with view and case - please help
Next
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: Re: using OID as primary key