Re: update behavior - Mailing list pgsql-admin

From Scott Ribe
Subject Re: update behavior
Date
Msg-id BE13CDCE-A689-4627-9B7F-572765CD9FBB@elevated-dev.com
Whole thread Raw
In response to Re: update behavior  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
> On Jun 19, 2025, at 11:31 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
> Correct.  You need a trigger to prevent the update.  There is one provided: suppress_redundant_updates_trigger()

Or, in my case that prompted this question, I need a WHERE clause for the ON CONFLICT UPDATE...





pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: update behavior
Next
From: Tom Lane
Date:
Subject: Re: update behavior