RE: OID as Primary Key

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jonas Bengtsson <jonas(dot)b(at)home(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: RE: OID as Primary Key
Date: 2001-03-22 17:09:12
Message-ID: Pine.BSF.4.21.0103220906270.41849-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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..

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marko Kreen 2001-03-22 17:12:39 Re: Call for platforms
Previous Message Stephan Szabo 2001-03-22 17:06:06 Re: Foreign keys/unique values and views