On Wed, 27 Nov 2002, fred wrote:
> Thank you for your quick answer,
> I'm affraid I made a mistake on my mail.
> I really wanted to automaticly delete line in the 'fact' table when I delete
> a line in the 'fact' table.
> But when I suppress a line in the 'coop' table I still have the related line
> in the 'fact' table.
> Do you think there is a mistake in my sql syntaxe ?
Not really, and on my 7.3b2 system (should be pretty much the same as
7.2.3 for the integrity constraints, since the only change I remember
being made was pretty unrelated) a delete from coop deletes all the rows
Can you give a complete example (including some inserts and deletes) so we
can try it?
pgsql-admin by date
|Next:||From: Hugh Esco||Date: 2002-11-27 17:03:33|
|Subject: Re: Problems invoking psql, was: Re: Troubles at|
|Previous:||From: fred||Date: 2002-11-27 16:51:00|
|Subject: Re: CASCADE PB|