Re: Trigger with WHEN clause (WIP)

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Trigger with WHEN clause (WIP)
Дата
Msg-id 20091016080128.M29748@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: Trigger with WHEN clause (WIP)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Trigger with WHEN clause (WIP)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, 16 Oct 2009, Tom Lane wrote:

> I note BTW that we have some ad-hoc logic already that arranges to
> suppress queuing of AFTER events for FK triggers, if the FK column
> value has not changed.  It might be interesting to look at whether
> that hack could be unified with the user-accessible feature.  It's
> essentially a WHEN OLD.x IS NOT DISTINCT FROM NEW.x test.

Note that one of those cases (RI_TRIGGER_FK) is a bit special due to the
transaction id test. It might be worth seeing if a better solution is
possible to cover the case in the comment if the above becomes possible,
though.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: operator exclusion constraints [was: generalized index constraints]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Trigger with WHEN clause (WIP)