Re: After delete trigger problem - Mailing list pgsql-general

From Tom Lane
Subject Re: After delete trigger problem
Date
Msg-id 3447.1226120516@sss.pgh.pa.us
Whole thread Raw
In response to Re: After delete trigger problem  ("Teemu Juntunen" <teemu.juntunen@e-ngine.fi>)
List pgsql-general
"Teemu Juntunen" <teemu.juntunen@e-ngine.fi> writes:
> Also according to the manual BEFORE DELETE trigger should launch before
> casading delete, so I changed the trigger

> CREATE TRIGGER "BTD_Y" BEFORE DELETE ON chlid  FOR EACH ROW EXECUTE
> PROCEDURE fn_td_y();

> with no help.

In that case your problem is not about whether you are firing before the
RI action happens; you've got some other bug instead.  It's hard to see
what from the limited details you provided, though.  Can you put
together a complete example?

            regards, tom lane

pgsql-general by date:

Previous
From: Owen Hartnett
Date:
Subject: Re: postgresql and Mac OS X
Next
From: Craig Ringer
Date:
Subject: Re: Short CVS question, history