Request a Demo
Home   >   mailing lists

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

From David G. Johnston
Subject Re: unique constraint violation on multiple-rows update
Date
Msg-id CAKFQuwZp1Qcdg9G_HEwDjNvvbHtZxU1Sz7xkJCm+G+psqwpO3Q@mail.gmail.com
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
On Sun, Apr 19, 2026 at 6:44 AM Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
> Running that does violate the (non-deferred) UNIQUE
> constraint on the table column, however.

You know about deferred constraints, you should use them here.  This is one of the key use cases motivating their existence.

David J.

pgsql-general by date:

Previous
From: Saulo José Benvenutti
Date:
Subject: ANN: storage_engine 1.0.7 – columnar + row-compressed Table Access Methods for PostgreSQL 16-18
Next
From: Karsten Hilbert
Date:
Subject: Re: unique constraint violation on multiple-rows update