Re: After delete trigger problem

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