Re: row from index tuple

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: row from index tuple
Date: 2026-02-04 17:23:54
Message-ID: CANzqJaCDSAEiJf__-T9SPeQaXvKJVFEKS9MGay0u0qxLBzSQTQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Feb 4, 2026 at 11:09 AM Scott Ribe <scott_ribe(at)elevated-dev(dot)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!

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2026-02-04 17:42:01 Re: row from index tuple
Previous Message Scott Ribe 2026-02-04 16:09:25 row from index tuple