Hi,
thanks for answers!
I tried to rename the function
ALTER TRIGGER td_y ON child RENAME TO "BTD_Y";
with no help.
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. Any other ideas?
Regards,
Teemu Juntunen
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Teemu Juntunen" <teemu.juntunen@e-ngine.fi>
Cc: "PostgreSQL" <pgsql-general@postgresql.org>
Sent: Friday, November 07, 2008 9:23 PM
Subject: Re: [GENERAL] After delete trigger problem
> "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