Re: Determining if a table really changed in a trigger

From: Mitar <mmitar(at)gmail(dot)com>
To: Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Determining if a table really changed in a trigger
Date: 2021-10-26 20:34:56
Message-ID: CAKLmikPA6Nj65X_sbSh6XoROLuY_FeXd8AmpxuM-LWw5EnMxpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

On Tue, Oct 26, 2021 at 10:17 PM Mark Dilger
<mark(dot)dilger(at)enterprisedb(dot)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 trivial updates 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Dilger 2021-10-26 20:55:27 Re: Determining if a table really changed in a trigger
Previous Message Mark Dilger 2021-10-26 20:17:03 Re: Determining if a table really changed in a trigger