MIME-Version: 1.0
References: <A3158AF1-F385-469F-8FBF-0CC1670688DC@elevated-dev.com>
In-Reply-To: <A3158AF1-F385-469F-8FBF-0CC1670688DC@elevated-dev.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 4 Feb 2026 12:23:54 -0500
Message-ID: 
 <CANzqJaCDSAEiJf__-T9SPeQaXvKJVFEKS9MGay0u0qxLBzSQTQ@mail.gmail.com>
Subject: Re: row from index tuple
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000beb81f064a02d2d0"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaCDSAEiJf__-T9SPeQaXvKJVFEKS9MGay0u0qxLBzSQTQ%40mail.gmail.com>
Precedence: bulk

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

On Wed, Feb 4, 2026 at 11:09=E2=80=AFAM Scott Ribe <scott_ribe@elevated-dev=
.com>
wrote:

> How can I get from an index tuple to the row?
>
> The situation is that we're seeing deadlocks on inserts, because two
> different sources are sending rows that have the same unique constraint,
> when they should not be doing that. Would love to get to an example row t=
o
> hunt this down further.
>

When I see deadlocks, both records are in the log file.  You don't see
them, there are "?" placeholders. something else?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Feb 4, 2026 at 11:09=E2=80=AFAM S=
cott Ribe &lt;<a href=3D"mailto:scott_ribe@elevated-dev.com">scott_ribe@ele=
vated-dev.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_con=
tainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left:1px solid rgb(204,204,204);padding-left:1ex">How can I get fro=
m an index tuple to the row?<br>
<br>
The situation is that we&#39;re seeing deadlocks on inserts, because two di=
fferent sources are sending rows that have the same unique constraint, when=
 they should not be doing that. Would love to get to an example row to hunt=
 this down further.<br></blockquote><div><br></div><div>When I see deadlock=
s, both records are in the log file.=C2=A0 You don&#39;t see them, there ar=
e &quot;?&quot; placeholders. something else?</div><div><br></div></div><sp=
an class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D=
"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sa=
uce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&=
gt; lobster!</div></div></div></div></div></div>

--000000000000beb81f064a02d2d0--