Re: [BUG] Query with postgres fwd deletes more tuples than it should

From: jiaoshuntian(at)highgo(dot)com
To: "Daniil Davydov" <3danissimo(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [BUG] Query with postgres fwd deletes more tuples than it should
Date: 2025-09-17 05:46:31
Message-ID: 2bdb8641.1e1.1995635cfb4.Coremail.jiaoshuntian@highgo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I can reproduce the same issue using the script you provided.

I think a good way to fix would be to use `(tableoid, ctid)` together as the row
identifier in row-by-row updates/deletes. This combination is unique
across partitions and avoids the incorrect behavior, while still keeping
LIMIT support.

Best regards,
--
JiaoShuntian
HighGo Software Co., Ltd.

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Peter Eisentraut 2025-09-17 05:21:22 Remove PointerIsValid()