Re: Column level triggers

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Column level triggers
Дата
Msg-id 48F5A3F8.4090508@gmx.net
обсуждение исходный текст
Ответ на Re: Column level triggers  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: Column level triggers
Список pgsql-general
Scott Marlowe wrote:
> Since you can check which columns have changed, it's pretty easy to
> write a trigger that just skips its logic when none of the trigger
> columns have changed.

I think column-level triggers actually fire when one of the columns is
written to, not only when the value there is distinct from the previous
one.  This small difference is not easy to emulate by comparing OLD and
NEW in the trigger body.  Details might need to be checked in the
standard and existing implementations.

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Drupal and PostgreSQL - performance issues?
Следующее
От: "Laurent Wandrebeck"
Дата:
Сообщение: Re: Column level triggers