Re: row from index tuple - Mailing list pgsql-admin

From Ron Johnson
Subject Re: row from index tuple
Date
Msg-id CANzqJaCDSAEiJf__-T9SPeQaXvKJVFEKS9MGay0u0qxLBzSQTQ@mail.gmail.com
Whole thread
In response to row from index tuple  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: row from index tuple
List pgsql-admin
On Wed, Feb 4, 2026 at 11:09 AM 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 to 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?

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

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: row from index tuple
Next
From: Scott Ribe
Date:
Subject: Re: row from index tuple