Horton

Re: [BUG?] check_exclusion_or_unique_constraint false negative

Mihail Nikalayeu <mihailnikalayeu@gmail.com>

View thread View on postgr.es
From: Mihail Nikalayeu <mihailnikalayeu@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>, Peter Geoghegan <pg@bowt.ie>, "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Andres Freund <andres@anarazel.de>
Date: 2025-11-13T12:22:38Z
Lists: pgsql-hackers 
Hello, Amit!

On Tue, Aug 26, 2025 at 1:08 PM Amit Kapila <amit.kapila16@gmail.com> wrote:

> I think it is better to document this race somewhere in a logical
> replication document for now unless we have a consensus on a way to
> move forward.

I have added a draft of the documentation patch in related thread [0].

[0]: https://www.postgresql.org/message-id/flat/CADzfLwU_o%2BeL2z9ifkpW2%2BkSJEXEbXkTmomvoEw-UY9CzgOn1A%40mail.gmail.com#2919d50a20b530092ec7e6ec71709697

Mikhail.

Commits

  1. Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.