From: Steve Boyle \(Roselink\) <boylesa@roselink.co.uk>
To: Roberto Mello <rmello@cc.usu.edu>
To: Paulo J. Matos <pocm@rnl.ist.utl.pt>
Cc: pgsql-sql@postgresql.org
Subject: Re: On delete cascade!
Date: Tue, 15 Jan 2002 11:32:50 -0000
Message-ID: <009901c19db8$5d781a60$c55869d5@dualtower> (raw)
References: <87zo3gfzdj.fsf@localhost.localdomain>
<20020115062933.GA27415@cc.usu.edu>
Is the , after socio the problem here?
sb
----- Original Message -----
From: "Roberto Mello" <rmello@cc.usu.edu>
To: "Paulo J. Matos" <pocm@rnl.ist.utl.pt>
Cc: <pgsql-sql@postgresql.org>
Sent: Tuesday, January 15, 2002 6:29 AM
Subject: Re: [SQL] On delete cascade!
> On Mon, Jan 14, 2002 at 08:31:36PM +0000, 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);
>
> Ola Paulo,
>
> You need to take a look at the PostgreSQL documentation as well. Just
> reading your college databases book won't cut it most of the time.
>
> PostgreSQL has excellent documentation, especially the reference manual.
> Take a look at it. So far both of your questions could have been answered
> by taking a quick glance at the docs.
>
> http://www.postgresql.org/idocs/
>
> -Roberto
>
> --
> +----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
> Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
> http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
> Information is the greatest weapon of power to the modern wizard.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
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: boylesa@roselink.co.uk, rmello@cc.usu.edu, pocm@rnl.ist.utl.pt
Subject: Re: On delete cascade!
In-Reply-To: <009901c19db8$5d781a60$c55869d5@dualtower>
* 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