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

From Tom Lane
Subject Re: After delete trigger problem
Date
Msg-id 22267.1226085802@sss.pgh.pa.us
Whole thread Raw
In response to After delete trigger problem  ("Teemu Juntunen" <teemu.juntunen@e-ngine.fi>)
List pgsql-general
"Teemu Juntunen" <teemu.juntunen@e-ngine.fi> writes:
> CREATE TRIGGER td_y  AFTER DELETE ON chlid  FOR EACH ROW EXECUTE PROCEDURE fn_td_y();

> It seems that SELECT results to null, so the master has already deleted the row. Is this intended and how can I solve
this?

Your trigger is firing after the RI triggers.  If you want it to fire
before, give it a name that is before them (in ASCII order).

            regards, tom lane

pgsql-general by date:

Previous
From: "Teemu Juntunen"
Date:
Subject: After delete trigger problem
Next
From: Erik Jones
Date:
Subject: Re: After delete trigger problem