Parent table has not oid?

["Zhidian Du" <duzhidian@xxxxxxxxxxx>]

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