Parent table has not oid?

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