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: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

are there any disadvantages of using OID as the primary key for any
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?




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-2017 The PostgreSQL Global Development Group