Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 5095D4758FE; Sun, 10 Nov 2002 01:04:07 -0500 (EST)
Received: from hotmail.com (f61.law12.hotmail.com [64.4.19.61])
	by postgresql.org (Postfix) with ESMTP
	id B9593475425; Sun, 10 Nov 2002 01:04:06 -0500 (EST)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Sat, 9 Nov 2002 22:04:06 -0800
Received: from 128.123.37.105 by lw12fd.law12.hotmail.msn.com with HTTP;
	Sun, 10 Nov 2002 06:04:05 GMT
X-Originating-IP: [128.123.37.105]
From: "Zhidian Du" <duzhidian@hotmail.com>
To: pgsql-php@postgresql.org, pgsql-sql@postgresql.org,
	sszabo@megazone23.bigpanda.com
Subject: Parent table has not oid? 
Date: Sat, 09 Nov 2002 23:04:05 -0700
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F61oWoCaNCnFjtCEhgv00004919@hotmail.com>
X-OriginalArrivalTime: 10 Nov 2002 06:04:06.0097 (UTC)
	FILETIME=[F9FA1C10:01C2887E]
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/43
X-Sequence-Number: 1625





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