Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1t2vsF-008hId-Pz
	for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Oct 2024 17:07:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1t2vsC-009dcQ-UN
	for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Oct 2024 17:07:17 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <michail.nikolaev@gmail.com>)
	id 1t2vsC-009dcI-KJ
	for pgsql-hackers@lists.postgresql.org; Mon, 21 Oct 2024 17:07:16 +0000
Received: from mail-ej1-x634.google.com ([2a00:1450:4864:20::634])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <michail.nikolaev@gmail.com>)
	id 1t2vsA-002FoQ-CX
	for pgsql-hackers@postgresql.org; Mon, 21 Oct 2024 17:07:16 +0000
Received: by mail-ej1-x634.google.com with SMTP id a640c23a62f3a-a99fa009adcso260480966b.0
        for <pgsql-hackers@postgresql.org>; Mon, 21 Oct 2024 10:07:14 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1729530432; x=1730135232; darn=postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=mNGx4TS7007mS41hsrBWK/Q1U5IRAxx7D3OtdZD2nFc=;
        b=LjANutJMQ6cRiPQ2mjOTBQibYLd3sD740ZaZXnECL/EzBArX8zSI1Mbnh7QdJHPhTs
         mIBp4mATn3EwgY1R7iAHbgtny+j4c0ZQloz9lnAynLUsgeIc/1GIrRWhI1o0HgoXx/an
         NRtfHkLb1r6cMM3Hft3gndGlAGoa/SdqjTNymNlojpgLUJy++SUCBpvs/v/cyiRv+JEH
         Uy+Cbl+LyewRmlIT2v2GBrfKmADNuOYpdE/aATjoJC6zVsdcNjTyuMETcUXDwT50TcRm
         UMU29bn4FuhWFpe8Ug9xSdvFVolOhzeB+80Fh5cKfra/KwKw0l5zyWcSlU4FKzEmYSzW
         bX3g==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1729530432; x=1730135232;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=mNGx4TS7007mS41hsrBWK/Q1U5IRAxx7D3OtdZD2nFc=;
        b=BNk2ZywY3zztYiU0PvPpF6zQmasi2TCn588ww+eGAiYC+kV+PCIB9GiPGn/7N80OAx
         QWs0cvfuUHZhcP/mqoksBeOn+LrDRAxKxvfmuEQE/lc9ywdW3/ULkuwZf6Y8biQ/bc6g
         R2wniVwzYtStqd20L2mQaJpbxojWgf7DRVas0i0Crf/CJSpKKzTN7xnqt+owO9KCzO3g
         fuxHACISsq241asnzh/rWAwKrjwa1YyEfZO25s78x61KuPphnfutRxdVyfBVoW5hOUS/
         h2QoHz2lvzReYlA7J6C1iMigNbOEups1f4WJWcMZN+VzovwYzXUBlpCqvtHzZcnwDfDh
         pRdA==
X-Forwarded-Encrypted: i=1; AJvYcCWByprAwGST+vidCCGvlhHrY7KOqK/j65GxSIVxjDkL+1ltYQN8LBAH9cSU6usB/ZkhZ6hEhNSN0WtNP6zJ@postgresql.org
X-Gm-Message-State: AOJu0YwAOtiPnR89fSHlEJuY/efouMIXV56fjYBj9FXVK0kgAop9NwJ+
	BubOiU5CyLgZFxN9TUgl5CalG5Va3HAsAF6KRnIyncfY8eeJzQkHusDMuG9Nw2PVwgP93Ut3MXW
	Jh+YD8tDpEAOGUE3+n/a5ush2+t8=
X-Google-Smtp-Source: AGHT+IG+BvmKdYNSQVgzFZaGHzgveSGl4+OhZRIom5Ounu5gsUbAhVnIbWOnsznmhvs7lI+mqG5ktJTgvwnu8VYcaRM=
X-Received: by 2002:a05:6402:1d52:b0:5cb:65f4:7d91 with SMTP id
 4fb4d7f45d1cf-5cb65f47da5mr7237664a12.29.1729530432083; Mon, 21 Oct 2024
 10:07:12 -0700 (PDT)
MIME-Version: 1.0
References: <CANtu0oiktqQ2pwExoXqDpByXNCJa-KE5vQRodTRnmFHN_+qwHg@mail.gmail.com>
 <CANtu0ohU2XRV9shtu14CffLPDS1x10q7ebOGf-vX0p+45_L8jw@mail.gmail.com>
 <CANtu0oh0tspW-xWzDGWP9ehz96KPt9aUP1c9JYhdBYxKsB0jpA@mail.gmail.com>
 <CANtu0ohUB9ky45iiMAYN1fGyt82+cg=+UYBom=P7drb+=97G9w@mail.gmail.com>
 <TYAPR01MB56921C9C3D21B0D62FF76330F5B22@TYAPR01MB5692.jpnprd01.prod.outlook.com>
 <CANtu0og=5v4j8onS4nyJ4zMPdh-EPFxmiEi5PLoyZrmqHA6RKw@mail.gmail.com>
 <CAA4eK1Jfb0xviXYon-_TvHNKeAY7ngAeo++Knu-0RPR6EkSBjA@mail.gmail.com>
 <CANtu0ohHmYXsK5bxU9Thcq1FbELLAk0S2Zap0r8AnU3OTmcCOA@mail.gmail.com>
 <CAA4eK1+_V1PWXrrgAM01p+CByP6JwYRxejZrcxOu83a-v_+zZg@mail.gmail.com>
 <CANtu0ogDDQnXbrv6p7Xtc2dT_MZ1fjdPgB9-0B5Lw1b4pQGd2A@mail.gmail.com>
 <OS0PR01MB5716FFD8DBBADB55E8E6935994852@OS0PR01MB5716.jpnprd01.prod.outlook.com>
 <CANtu0oiziTBM8+WDtkktMZv0rhGBroYGWwqSQW+MzOWpmk-XEw@mail.gmail.com>
 <OS0PR01MB5716E30952F542E256DD72E294802@OS0PR01MB5716.jpnprd01.prod.outlook.com>
 <CANtu0oh69b+VCiASX86dF_eY=9=A2RmMQ_+0+uxZ_Zir+oNhhw@mail.gmail.com>
In-Reply-To: <CANtu0oh69b+VCiASX86dF_eY=9=A2RmMQ_+0+uxZ_Zir+oNhhw@mail.gmail.com>
From: Michail Nikolaev <michail.nikolaev@gmail.com>
Date: Mon, 21 Oct 2024 19:06:59 +0200
Message-ID: <CANtu0og_4FVsRMxXue8SXUn03MwBAT0SiZSib_wcPMLDkpn-RA@mail.gmail.com>
Subject: Re: [BUG?] check_exclusion_or_unique_constraint false negative
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>
Content-Type: multipart/alternative; boundary="0000000000000861b70624ffaf22"
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/CANtu0og_4FVsRMxXue8SXUn03MwBAT0SiZSib_wcPMLDkpn-RA%40mail.gmail.com>
Precedence: bulk

--0000000000000861b70624ffaf22
Content-Type: text/plain; charset="UTF-8"

Hello, Hou!

I have sent [0] reproducer within the context of conflict detection and
resolution to the original thread.

[0]:
https://www.postgresql.org/message-id/flat/CANtu0ojMjAwMRJK%3DH8y0YBB0ZEcN%2BJbdZeoXQn8dWO5F67jgsA%40mail.gmail.com#f5d1baf4702685aedf23daa9addc012e

>

--0000000000000861b70624ffaf22
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hello,=C2=A0Hou!</div><div><br></div><div>I have sent=
 [0] reproducer within the context=C2=A0of conflict detection and resolutio=
n to the original thread.</div><div><br></div><div>[0]:=C2=A0<a href=3D"htt=
ps://www.postgresql.org/message-id/flat/CANtu0ojMjAwMRJK%3DH8y0YBB0ZEcN%2BJ=
bdZeoXQn8dWO5F67jgsA%40mail.gmail.com#f5d1baf4702685aedf23daa9addc012e">htt=
ps://www.postgresql.org/message-id/flat/CANtu0ojMjAwMRJK%3DH8y0YBB0ZEcN%2BJ=
bdZeoXQn8dWO5F67jgsA%40mail.gmail.com#f5d1baf4702685aedf23daa9addc012e</a><=
/div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex">
</blockquote></div></div>

--0000000000000861b70624ffaf22--