Request a Demo
Home   >   mailing lists

Re: unique constraint violation on multiple-rows update - Mailing list pgsql-general

From Tom Lane
Subject Re: unique constraint violation on multiple-rows update
Date
Msg-id 4040650.1776611867@sss.pgh.pa.us
Whole thread
In response to Re: unique constraint violation on multiple-rows update  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: unique constraint violation on multiple-rows update
List pgsql-general
Tree view 
Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> Am Sun, Apr 19, 2026 at 06:54:02AM -0700 schrieb David G. Johnston:
>> You know about deferred constraints, you should use them here.  This is one
>> of the key use cases motivating their existence.

> Indeed. I was of the mistaken impression that UNIQUE
> constraints were not deferrable ...

Once upon a time they were not, but we fixed that years ago.

            regards, tom lane

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: unique constraint violation on multiple-rows update
Next
From: Igor Korot
Date:
Subject: Re: List of encodings