"Teemu Juntunen" <teemu(dot)juntunen(at)e-ngine(dot)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