Re: using OID as primary key - Mailing list pgsql-sql

From JanWieck@t-online.de (Jan Wieck)
Subject Re: using OID as primary key
Date
Msg-id 200007211157.NAA04499@hot.jw.home
Whole thread Raw
In response to using OID as primary key  (Markus Wagner <wagner@imsd.uni-mainz.de>)
Responses Re: using OID as primary key  (darcy@druid.net (D'Arcy J.M. Cain))
List pgsql-sql
Markus Wagner wrote:
> 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?
   Currently OID is not supported for references. Has to do with   some checks done in the RI  triggers,  using  SPI
functions.  We're thinking about a solution...
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #




pgsql-sql by date:

Previous
From: Markus Wagner
Date:
Subject: using OID as primary key
Next
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: using OID as primary key