"Zhidian Du" <duzhidian@xxxxxxxxxxx> writes: > CREATE TABLE Link ( > Protein_ID oid > CONSTRAINT one > REFERENCES Protein (oid) > ON DELETE CASCADE, > Link varchar(128) > ); > When I insert a record into this child table, it says > "ERROR: constraint one: table protein does not have an attribute oid" How old is your Postgres? IIRC, this was made to work in 7.2 or thereabouts. Note that using OID as a foreign key is not really a good idea, because it's problematic to dump and restore. You'd be better off with a serial column as primary key. regards, tom lane
