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

Поиск
Список
Период
Сортировка
От jiaoshuntian@highgo.com
Тема Re: [BUG] Query with postgres fwd deletes more tuples than it should
Дата
Msg-id 2bdb8641.1e1.1995635cfb4.Coremail.jiaoshuntian@highgo.com
обсуждение исходный текст
Ответ на [BUG] Query with postgres fwd deletes more tuples than it should  (Daniil Davydov <3danissimo@gmail.com>)
Ответы Re: [BUG] Query with postgres fwd deletes more tuples than it should
Список 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.

В списке pgsql-hackers по дате отправления: