Re: [BUG?] check_exclusion_or_unique_constraint false negative

Mihail Nikalayeu <mihailnikalayeu@gmail.com>

From: Mihail Nikalayeu <mihailnikalayeu@gmail.com>

To: "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>, Peter Geoghegan <pg@bowt.ie>

Cc: Amit Kapila <amit.kapila16@gmail.com>, "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Andres Freund <andres@anarazel.de>

Date: 2025-06-10T06:00:00Z

Lists: pgsql-hackers

Attachments

v7-0001-Add-an-isolation-test-to-reproduce-a-dirty-snapsh.patch (application/x-patch) patch v7-0001
v7-0002-Fix-btree-index-scan-concurrency-issues-with-dirt.patch (application/x-patch) patch v7-0002

Hello!

Rebased\reworked to align with the changes of [0].

Best regards.

[0]: https://www.postgresql.org/message-id/flat/CAH2-WznZBhWqDBDVGh1VhVBLgLqaYHEkPhmVV7mJCr1Y3ZQhQQ%40mail.gmail.com#d6f1debb1405d1b4a983cbb46b24f41b

Commits

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