Request a Demo
Home   >   mailing lists

Re: [BUG] Query with postgres fwd deletes more tuples than it should - Mailing list pgsql-hackers

From jiaoshuntian@highgo.com
Subject Re: [BUG] Query with postgres fwd deletes more tuples than it should
Date
Msg-id 2bdb8641.1e1.1995635cfb4.Coremail.jiaoshuntian@highgo.com
Whole thread Raw
In response to [BUG] Query with postgres fwd deletes more tuples than it should  (Daniil Davydov <3danissimo@gmail.com>)
Responses Re: [BUG] Query with postgres fwd deletes more tuples than it should
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Remove PointerIsValid()
Next
From: Amit Kapila
Date:
Subject: Re: [Patch] add new parameter to pg_replication_origin_session_setup