Parent table has not oid?

From: "Zhidian Du" <duzhidian(at)hotmail(dot)com>
To: pgsql-php(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, sszabo(at)megazone23(dot)bigpanda(dot)com
Subject: Parent table has not oid?
Date: 2002-11-10 06:04:05
Message-ID: F61oWoCaNCnFjtCEhgv00004919@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php pgsql-sql

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

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Tom Lane 2002-11-10 13:50:24 Re: [SQL] Parent table has not oid?
Previous Message Bruno Wolff III 2002-11-09 21:40:18 Re: Transaction including two web page + timer

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-11-10 13:50:24 Re: [SQL] Parent table has not oid?
Previous Message Zhidian Du 2002-11-10 06:01:41 table protein does not have an attribute oid? why?