Re: Statement-level triggers and inheritance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Statement-level triggers and inheritance
Дата
Msg-id 3187.1227909559@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Statement-level triggers and inheritance  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: Statement-level triggers and inheritance  (Robert Treat <xzilla@users.sourceforge.net>)
Список pgsql-hackers
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> Looks like inheritance causes a statement-level trigger to fire on
> the last evaluated table in the inheritance chain. Is this the
> desired behavior?

Hm, I think whoever wrote the statement-level trigger code completely
forgot to consider the possibility of multiple target relations.  It's
not even consistent between BEFORE and AFTER triggers for this case.

My feeling is that it ought to fire such triggers on *each* target.
        regards, tom lane


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

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Statement-level triggers and inheritance
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Fixing contrib/isn for float8-pass-by-value