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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Teemu Juntunen" <teemu(dot)juntunen(at)e-ngine(dot)fi>
Cc: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, November 07, 2008 9:23 PM
Subject: Re: [GENERAL] After delete trigger problem

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