Re: update behavior

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: update behavior
Date: 2025-06-19 17:34:19
Message-ID: BE13CDCE-A689-4627-9B7F-572765CD9FBB@elevated-dev.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Jun 19, 2025, at 11:31 AM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)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...

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2025-06-19 17:35:37 Re: update behavior
Previous Message David G. Johnston 2025-06-19 17:31:59 Re: update behavior