Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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