on delete cascade

From: MAZURU(at)aol(dot)com
To: pgsql-admin(at)postgresql(dot)org
Cc: mazuru(at)prodigy(dot)net
Subject: on delete cascade
Date: 2002-09-12 20:59:22
Message-ID: 10e.173512c8.2ab2926a@aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

to: anyone who can help:

i am developing a db in pl/pgsql at work and i am having problems with one
final part; the deleting of ref. int. rows. there are three tables, which i
will list below as close as possible to what i remember (i'm at home and
don't have my notes).

create table goodbye (
goodbye_id serial primary key,
whenn text,
wheree text,
how text,
isbn int
);

create table hello (
hello_id serial primary key,
goodbye_id int,
how text,
isbn int,
constraints hello_goodbye_id_fk foreign key references goodbye(goodbye_id) on
delete cascade
);

create table aidos (
adios_id serial primary key,
cost money,
title text
);

create table goodbye_adios (
goodbye_id int,
adios_id int,
constraint goodbye_adios_goodbye_id_fk foreign key references
goodbye(goodbye_id) on delete cascade,
constraint goodbye_adios_adios_id_fk foreign key references adios(adios_id)
on delete cascade
);

like i said, this is as close as i can remember.

the problem that occurs is that when i do a delete statement on the
goodbye_adios table, it will automatically delete from the goodbye_adios
table and the goodbye table, but not the record from the adios table. i
searched all day and seemed to be doing what the docs told me to, but to no
avail. it's been bothering me all night so if anybody knows how to work the
cascade effect properly please email me back at either of these addresses;

mazuru(at)prodigy(dot)net
mazuru(at)aol(dot)com
mzouroudis(at)idealcorp(dot)com

thanks in advance for the help,

mike

Browse pgsql-admin by date

  From Date Subject
Next Message Toshyro 2002-09-12 22:24:17 ERROR: No such attribute or function 'oid'
Previous Message Mel Jamero 2002-09-12 20:44:33 Re: Vaccuum/Analyze