Re: update behavior - Mailing list pgsql-admin

From Scott Ribe
Subject Re: update behavior
Date
Msg-id 0D31EA2C-9038-4C2D-A4CD-E602809F16CC@elevated-dev.com
Whole thread Raw
Responses Re: update behavior
List pgsql-admin
> On Jun 19, 2025, at 11:34 AM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
>
>> 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...

Wait, should suppress_redundant_updates_trigger be used even in this case? Would it suppress the update before the
constraintchecks and invocation of the ON CONFLICT clause??? 




pgsql-admin by date:

Previous
From: akshay polji
Date:
Subject: Re: alter the datatype of Partition Key
Next
From: Scott Ribe
Date:
Subject: Re: update behavior