From: pocm@rnl.ist.utl.pt
To: pgsql-sql@postgresql.org
Subject: On delete cascade!
Date: 14 Jan 2002 20:31:36 +0000
Message-ID: <87zo3gfzdj.fsf@localhost.localdomain> (raw)
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pocm@rnl.ist.utl.pt
Subject: Re: On delete cascade!
In-Reply-To: <87zo3gfzdj.fsf@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox