Dear All:
I want to create a delete cascade in children tables. The primary key of
parent table is oid.
CREATE TABLE Link ( Protein_ID oid, Link varchar(128) CONSTRAINT one REFERENCES Protein (oid) ON DELETE
CASCADE
);
Create child table is ok.
When I insert a record into this child table, it says
"ERROR: constraint one: table protein does not have an attribute oid"
Why?
Thanks.
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail