From: | Erle Czar Mantos <erle(at)hindang(dot)msuiit(dot)edu(dot)ph> |
---|---|
To: | "Paulo J(dot) Matos" <pocm(at)rnl(dot)ist(dot)utl(dot)pt> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: On delete cascade! |
Date: | 2002-02-26 07:53:02 |
Message-ID: | Pine.LNX.4.33L2.0202261552170.1435-100000@hindang.msuiit.edu.ph |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
To You:
The problem is on the comman after the word "socio", it shouldn't
have been there!
Erle
On 14 Jan 2002, Paulo J. Matos wrote:
> 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,
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2002-02-26 08:02:58 | Re: About referential integrity. |
Previous Message | Kancha . | 2002-02-26 07:51:39 | Re: [SQL] transaction abortion |