Skip site navigation (1) Skip section navigation (2)

using OID as primary key

From: Markus Wagner <wagner(at)imsd(dot)uni-mainz(dot)de>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: using OID as primary key
Date: 2000-07-21 11:47:43
Message-ID: 3978385E.2182D8B4@imsd.uni-mainz.de (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-sql by date

Next:From: Jan WieckDate: 2000-07-21 11:57:17
Subject: Re: using OID as primary key
Previous:From: Jan WieckDate: 2000-07-21 11:02:44
Subject: Re: [BUGS] problem with view and case - please help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group