Re: oid not "UNIQUE" for use as FOREIGN KEY? - Mailing list 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.