Postgres Pro
Downloads
Home   >   mailing lists

Re: Determining if a table really changed in a trigger - Mailing list pgsql-general

From Mitar
Subject Re: Determining if a table really changed in a trigger
Date
Msg-id CAKLmikPA6Nj65X_sbSh6XoROLuY_FeXd8AmpxuM-LWw5EnMxpQ@mail.gmail.com
Whole thread Raw
In response to Re: Determining if a table really changed in a trigger  (Mark Dilger <mark.dilger@enterprisedb.com>)
Responses Re: Determining if a table really changed in a trigger
List pgsql-general
Tree view 
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 by date:

Previous
From: Mark Dilger
Date:
Subject: Re: Determining if a table really changed in a trigger
Next
From: Mark Dilger
Date:
Subject: Re: Determining if a table really changed in a trigger