Re: CASCADE PB

On Wed, 27 Nov 2002, fred wrote:

> Hello,
> I use postgreSQL 7.2.3 and I have trouble on deleting.
> I would like to automaticly delete line in the 'coop' table when I dlete the
> line in the 'fact' table but it is not ok.
> Where is my mistake ?

On delete cascade goes the other direction.  What you've written says that
for any coop row that is deleted associated fact rows should be removed
not the other way around.  AFAICT your schema allows multiple fact rows
to reference a single coop row which means deleting the coop row will fail
unless this is the only fact row.

> This is my database:
>
> create table coop (
> id_coop serial not null,
> nom_coop varchar(50) not null,
> primary key(id_coop)
> );
>
> create table fact (
> id_fact serial not null,
> id_coop integer references coop(id_coop) on delete cascade,
> date_fact timestamp not null,
> montant_fact decimal(6,3),
> primary key(id_fact)
> );
>
> Thank's for your support.