MIME-Version: 1.0
References: <CANtu0oiktqQ2pwExoXqDpByXNCJa-KE5vQRodTRnmFHN_+qwHg@mail.gmail.com>
 <CANtu0ohU2XRV9shtu14CffLPDS1x10q7ebOGf-vX0p+45_L8jw@mail.gmail.com>
In-Reply-To: <CANtu0ohU2XRV9shtu14CffLPDS1x10q7ebOGf-vX0p+45_L8jw@mail.gmail.com>
From: Michail Nikolaev <michail.nikolaev@gmail.com>
Date: Wed, 24 Jul 2024 22:01:23 +0200
Message-ID: <CANtu0oh0tspW-xWzDGWP9ehz96KPt9aUP1c9JYhdBYxKsB0jpA@mail.gmail.com>
Subject: Re: [BUG?] check_exclusion_or_unique_constraint false negative
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Andres Freund <andres@anarazel.de>
Content-Type: multipart/alternative; boundary="000000000000d5106d061e03be1f"
Archived-At: <https://www.postgresql.org/message-id/CANtu0oh0tspW-xWzDGWP9ehz96KPt9aUP1c9JYhdBYxKsB0jpA%40mail.gmail.com>
Precedence: bulk

--000000000000d5106d061e03be1f
Content-Type: text/plain; charset="UTF-8"

Hello, everyone!

Updates so far:
* issue happens with both LOGGED and UNLOGGED relations
* issue happens with DirtySnapshot
* not happens with SnapshotSelf
* not happens with SnapshotAny
* not related to speculative inserted tuples - I have commented the code of
its insertion - and the issue continues to occur.

Best regards,
Mikhail.

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

<div dir=3D"ltr">Hello, everyone!<div><br></div><div>Updates so far:</div><=
div>* issue=C2=A0happens with both LOGGED and UNLOGGED relations</div><div>=
* issue happens with DirtySnapshot</div><div>* not happens with SnapshotSel=
f</div><div>* not happens with SnapshotAny</div><div>* not related to specu=
lative inserted tuples - I have commented the code of its insertion - and t=
he issue continues to occur.</div><div><br></div><div>Best regards,</div><d=
iv>Mikhail.</div></div>

--000000000000d5106d061e03be1f--