| 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?
| 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 |