Re: [BUG?] check_exclusion_or_unique_constraint false negative

Michail Nikolaev <michail.nikolaev@gmail.com>

From: Michail Nikolaev <michail.nikolaev@gmail.com>

To: "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>

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: 2024-11-23T16:20:41Z

Lists: pgsql-hackers

Attachments

v3-0001-Fix-possible-lost-tuples-in-non-MVCC-index-scans-.patch (application/octet-stream) patch v3-0001
v3-0002-Add-isolation-test-to-reproduce-dirty-snapshot-sc.patch (application/octet-stream) patch v3-0002

Hello, everyone!

A rebased version is attached. Also, fixed potential race in the test and
detailed commit messages.

Best regards,
Mikhail.

>

Commits

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