Re: After delete trigger problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: After delete trigger problem
Дата
Msg-id 22267.1226085802@sss.pgh.pa.us
обсуждение исходный текст
Ответ на After delete trigger problem  ("Teemu Juntunen" <teemu.juntunen@e-ngine.fi>)
Список 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 по дате отправления:

Предыдущее
От: "Teemu Juntunen"
Дата:
Сообщение: After delete trigger problem
Следующее
От: Erik Jones
Дата:
Сообщение: Re: After delete trigger problem