Re: Determining if a table really changed in a trigger

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Determining if a table really changed in a trigger
Дата
Msg-id CAHOFxGpCuubDP48nD-+Gfj7NCbHvvjBGJ4qeOFT7QYmdhEvoNQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Determining if a table really changed in a trigger  (Mitar <mmitar@gmail.com>)
Ответы Re: Determining if a table really changed in a trigger  (Mitar <mmitar@gmail.com>)
Список pgsql-general
If you end up with no rows changing from an insert or delete, something seems awry. Unless you mean 0 rows affected. Do after statement triggers still execute? I suppose they very well might.

Would the statement even execute if no rows get updated and that is prevented with before update? I would assume null is being returned rather than old if the trigger finds the row to be identical.

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

Предыдущее
От: Benedict Holland
Дата:
Сообщение: Re: ZFS filesystem - supported ?
Следующее
От: Ron
Дата:
Сообщение: Re: Need help understanding error message [RESOLVED]