table protein does not have an attribute oid? why?

From: "Zhidian Du" <duzhidian(at)hotmail(dot)com>
To: sszabo(at)megazone23(dot)bigpanda(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: table protein does not have an attribute oid? why?
Date: 2002-11-10 06:01:41
Message-ID: F140GdMNFmWAFsTmICl00000575@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Zhidian Du 2002-11-10 06:04:05 Parent table has not oid?
Previous Message LR 2002-11-09 16:51:40 execute a query in an other db