[SQL] Parent table has not oid?

[Zhidian Du]

Dear All:

Please disregerd my last email.

I want to create a delete cascade in children tables. The primary key of parent table is oid.


CREATE TABLE Link (
Protein_ID oid
CONSTRAINT one
REFERENCES Protein (oid)
ON DELETE CASCADE,
Link varchar(128)
);

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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html