Re: [BUG?] check_exclusion_or_unique_constraint false negative

Mihail Nikalayeu <mihailnikalayeu@gmail.com>

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>, peter@eisentraut.org

Date: 2025-09-13T12:07:33Z

Lists: pgsql-hackers

Attachments

v12-0002-Fix-logical-replication-conflict-detection-durin.patch (application/octet-stream) patch v12-0002
v12-0001-This-patch-introduces-new-injection-points-and-T.patch (application/octet-stream) patch v12-0001

Rebased.

Also, separate thread with some additional explanation is here:

https://www.postgresql.org/message-id/flat/CADzfLwXZVmbo11tFS_G2i+6TfFVwHU4VUUSeoqb+8UQfuoJs8A@mail.gmail.com

Commits

Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.
- 168d5805e4c0 9.5.0 cited