Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
Дата
Msg-id 5769.1311111047@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-bugs
Дерево обсуждения 
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> [ circular trigger relationships ]

> I expect the DELETE from a to delete related b record(s) and then succeed.
> Instead the UPDATE in b_del_trig causes delete of a to silently fail.

The update causes the already-selected target row version of the DELETE
to be obsoleted, so heap_delete finds it has nothing to do.  I'm
disinclined to mess with that logic.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE