RE: OID as Primary Key - Mailing list pgsql-general

From Stephan Szabo
Subject RE: OID as Primary Key
Date
Msg-id Pine.BSF.4.21.0103220906270.41849-100000@megazone23.bigpanda.com
Whole thread Raw
In response to RE: OID as Primary Key  ("Jonas Bengtsson" <jonas.b@home.se>)
Responses RE: OID as Primary Key  ("Jonas Bengtsson" <jonas.b@home.se>)
List pgsql-general
You can create indexes on them. It's specifically
a limitation in the fk related code.  IIRC, there
were a couple of places in the triggers that
would fail on execution if you tried to reference
oid, so it now fails on creation rather than
execution of constraints.  There are a bunch
of things that need to get done to those triggers
anyway, so possibly for 7.2.

On Thu, 22 Mar 2001, Jonas Bengtsson wrote:

> But why doesn't PostgreSQL complain when a create a unique index on oid? I
> think it is quite confusing..


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Foreign keys/unique values and views
Next
From: "Jonas Bengtsson"
Date:
Subject: RE: OID as Primary Key