Re: oid not "UNIQUE" for use as FOREIGN KEY?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Ernesto Baschny <ernst(at)baschny(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: oid not "UNIQUE" for use as FOREIGN KEY?
Date: 2001-10-23 06:33:38
Message-ID: Pine.BSF.4.21.0110222331310.49557-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Tue, 23 Oct 2001, Ernesto Baschny wrote:

> Now, what is the problem? "oid" for sure should be an UNIQUE
> field in each table, doesn't it? Is it a bug?

To your last two questions, no and yes. Unless you place a unique index
on oid, it is not actually guaranteed unique (due to potential
wraparound), however the alter code also doesn't yet handle referencing to
non-user columns.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nikola Milutinovic 2001-10-23 06:48:51 Re: Problems setting up PostgreSQL and Tomcat JDBC connection
Previous Message Stephan Szabo 2001-10-23 06:31:06 Re: UNION bug in 7.1.3?