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

Re: using OID as primary key

From: JanWieck(at)t-online(dot)de (Jan Wieck)
To: wagner(at)imsd(dot)uni-mainz(dot)de
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: using OID as primary key
Date: 2000-07-21 11:57:17
Message-ID: 200007211157.NAA04499@hot.jw.home (view raw or flat)
Thread:
Lists: 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(at)Yahoo(dot)com #



In response to

Responses

pgsql-sql by date

Next:From: D'Arcy J.M. CainDate: 2000-07-21 13:58:15
Subject: Re: using OID as primary key
Previous:From: Markus WagnerDate: 2000-07-21 11:47:43
Subject: using OID as primary key

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