Re: After delete trigger problem
От | Teemu Juntunen |
---|---|
Тема | Re: After delete trigger problem |
Дата | |
Msg-id | 1A06982497A3422A93321D7FC2C70F99@eng02 обсуждение исходный текст |
Ответ на | After delete trigger problem ("Teemu Juntunen" <teemu.juntunen@e-ngine.fi>) |
Ответы |
Re: After delete trigger problem
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: