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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
