Re: Getting track of foreign keys - Mailing list pgsql-general

From tmp
Subject Re: Getting track of foreign keys
Date
Msg-id pan.2004.09.16.11.54.42.435792@amossen.dk
Whole thread Raw
In response to Getting track of foreign keys  (tmp <skrald@amossen.dk>)
List pgsql-general
> * I have tried to create a trigger, that ensures the above. But this is,
> for some reason, not getting fired if the deletion of a slave row is a
> result of a foreign key cascading effect. So this is only of limited use.

I solved it:
The trigger should be fired BEFORE deletions and not after. Ofcourse.



pgsql-general by date:

Previous
From: "Rolf Østvik"
Date:
Subject: Re: Spacing in output
Next
From: "G. Thomas Yagel, Jr."
Date:
Subject: Vacuum related question