Re: [BUG?] check_exclusion_or_unique_constraint false negative

From:	Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To:	"Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>
Cc:	Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>
Subject:	Re: [BUG?] check_exclusion_or_unique_constraint false negative
Date:	2025-06-10 06:00:00
Message-ID:	CADzfLwU_wuHeApGSGm+jO=9DzE-ZugONPRk1m6qohY0T-UNB7w@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2024-07-14 18:01:50 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎  2024-07-21 15:27:01 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>   2024-07-24 20:01:23 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>    2024-07-31 20:57:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>     2024-08-01 05:54:37 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>      2024-08-01 09:25:36 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>       2024-08-02 04:56:40 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>        2024-08-02 17:08:39 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎         2024-08-05 10:16:20 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>          2024-08-05 11:11:50 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>           2024-08-12 03:32:32 from "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>            2024-08-12 11:11:26 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎             2024-08-15 08:06:03 from "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>              2024-08-16 13:31:55 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>               2024-10-21 17:06:59 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                2024-11-23 16:20:41 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                 2025-01-20 21:35:53 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                  2025-02-11 23:39:09 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                   2025-03-12 01:05:50 from Mihail Nikalayeu <michail(dot)nikolaev(at)gmail(dot)com> 📎                    2025-05-18 14:36:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                     2025-06-10 06:00:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                      2025-06-16 20:25:23 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                       2025-08-19 22:44:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                        2025-08-21 08:43:08 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                    2025-08-22 10:50:41 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                     2025-08-22 12:47:57 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                      2025-08-22 12:51:45 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                       2025-08-22 15:41:25 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                        2025-08-25 05:01:17 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                        2025-08-25 05:02:12 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                         2025-08-25 10:49:10 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                          2025-08-25 11:51:27 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                           2025-08-25 13:32:03 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                            2025-08-26 11:08:17 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                             2025-08-27 08:53:57 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                              2025-09-03 18:20:21 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                               2025-09-13 12:07:33 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                2025-10-25 14:55:52 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                 2025-10-28 18:06:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                  2025-10-28 19:44:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                             2025-11-13 12:22:38 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v7-0001-Add-an-isolation-test-to-reproduce-a-dirty-snapsh.patch	application/x-patch	5.8 KB
v7-0002-Fix-btree-index-scan-concurrency-issues-with-dirt.patch	application/x-patch	9.0 KB

In response to

• Re: [BUG?] check_exclusion_or_unique_constraint false negative at 2025-05-18 14:36:00 from Mihail Nikalayeu

Responses

• Re: [BUG?] check_exclusion_or_unique_constraint false negative at 2025-06-16 20:25:23 from Mihail Nikalayeu

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amit Kapila	2025-06-10 06:09:08	Re: Question on error code selection in conflict detection
Previous Message	jian he	2025-06-10 05:50:12	Re: Add SPLIT PARTITION/MERGE PARTITIONS commands