Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 621AF474E61
	for <pgsql-sql@postgresql.org>; Sun, 10 Nov 2002 01:01:42 -0500 (EST)
Received: from hotmail.com (f140.law12.hotmail.com [64.4.19.140])
	by postgresql.org (Postfix) with ESMTP id C308D474E53
	for <pgsql-sql@postgresql.org>; Sun, 10 Nov 2002 01:01:41 -0500 (EST)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Sat, 9 Nov 2002 22:01:41 -0800
Received: from 128.123.37.105 by lw12fd.law12.hotmail.msn.com with HTTP;
	Sun, 10 Nov 2002 06:01:41 GMT
X-Originating-IP: [128.123.37.105]
From: "Zhidian Du" <duzhidian@hotmail.com>
To: sszabo@megazone23.bigpanda.com
Cc: pgsql-sql@postgresql.org
Subject: table protein does not have an attribute oid? why? 
Date: Sat, 09 Nov 2002 23:01:41 -0700
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F140GdMNFmWAFsTmICl00000575@hotmail.com>
X-OriginalArrivalTime: 10 Nov 2002 06:01:41.0359 (UTC)
	FILETIME=[A3B4D7F0:01C2887E]
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/155
X-Sequence-Number: 10297




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