Re: Determining if a table really changed in a trigger

Поиск
Список
Период
Сортировка
От Mitar
Тема Re: Determining if a table really changed in a trigger
Дата
Msg-id CAKLmikPA6Nj65X_sbSh6XoROLuY_FeXd8AmpxuM-LWw5EnMxpQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Determining if a table really changed in a trigger  (Mark Dilger <mark.dilger@enterprisedb.com>)
Ответы Re: Determining if a table really changed in a trigger  (Mark Dilger <mark.dilger@enterprisedb.com>)
Список pgsql-general
Hi!

On Tue, Oct 26, 2021 at 10:17 PM Mark Dilger
<mark.dilger@enterprisedb.com> wrote:
> I can't tell from your post if you want the trivial update to be performed, but if not, would it work to filter
trivialupdates as:
 

No, I want to skip trivial updates (those which have not changed
anything). But my trigger is per statement, not per row. So I do not
think your approach works there? So this is why I am then making a
more complicated check inside the trigger itself.


Mitar

-- 
http://mitar.tnode.com/
https://twitter.com/mitar_m



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

Предыдущее
От: Mark Dilger
Дата:
Сообщение: Re: Determining if a table really changed in a trigger
Следующее
От: Mark Dilger
Дата:
Сообщение: Re: Determining if a table really changed in a trigger