Re: CASCADE PB

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: fred <fred(at)skyturn(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: CASCADE PB
Date: 2002-11-27 16:55:50
Message-ID: 20021127085301.E93967-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Wed, 27 Nov 2002, fred wrote:

> Ok,
> 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
from fact.

Can you give a complete example (including some inserts and deletes) so we
can try it?

Browse pgsql-admin by date

  From Date Subject
Next Message Hugh Esco 2002-11-27 17:03:33 Re: Problems invoking psql, was: Re: Troubles at
Previous Message fred 2002-11-27 16:51:00 Re: CASCADE PB