Received: from front2.netvisao.pt ([213.228.128.57])
	by postgresql.org (8.11.3/8.11.4) with SMTP id g0EKJQV77597
	for <pgsql-sql@postgresql.org>; Mon, 14 Jan 2002 15:19:26 -0500 (EST)
	(envelope-from pocm@rnl.ist.utl.pt)
Received: (qmail 4911 invoked from network); 14 Jan 2002 20:18:51 -0000
Received: from unknown (HELO localhost.localdomain) (217.129.243.231)
	by front2.netvisao.pt with SMTP; 14 Jan 2002 20:18:51 -0000
To: pgsql-sql@postgresql.org
Subject: On delete cascade!
From: pocm@rnl.ist.utl.pt (Paulo J. Matos)
Date: 14 Jan 2002 20:31:36 +0000
Message-ID: <87zo3gfzdj.fsf@localhost.localdomain>
Lines: 32
User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.1
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200201/146
X-Sequence-Number: 6233

Hi all,

On weak entities I've used ON DELETE CASCADE as mentioned in
"Databases Management Systems" by Raghu Ramakrishnan. But I get:
psql:tables.sql:43: ERROR:  parser: parse error at or near "ON"    

on tables like the following:

CREATE TABLE socio_ilumindado (
	cognome varchar,
	id integer,
	nome varchar,
	alcunha varchar,
	data_filiacao date,
	PRIMARY KEY(id),
 	FOREIGN KEY(id, nome, alcunha, data_filiacao) REFERENCES socio,
	ON DELETE CASCADE);


How can I change this to be compatible with postgresql?

TIA,
Best regards,

-- 
Paulo J. Matos : pocm(_at_)rnl.ist.utl.pt
Instituto Superior Tecnico - Lisbon    
Software & Computer Engineering - A.I.
 - > http://www.rnl.ist.utl.pt/~pocm 
 ---	
	Yes, God had a deadline...
		So, He wrote it all in Lisp!