Re: oid and oidvector

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> No, you can't use oid as a foreign key.  You must use a PRIMARY column.

Oh?

regression=# create table foo(f1 int);
CREATE
regression=# create unique index fooi on foo(oid);
CREATE
regression=# create table bar (ref oid references foo(oid));
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
CREATE
regression=#

I agree with the advice *not* to do this, but that doesn't mean it can't
be done.
        regards, tom lane