Re: Fix missing EvalPlanQual recheck for TID scans

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Fix missing EvalPlanQual recheck for TID scans
Дата
Msg-id CAApHDvqNH8AObaQh6PrDq_-X7Zg5G6hN4GeB7DYw84z3bc7kKg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fix missing EvalPlanQual recheck for TID scans  (Chao Li <li.evan.chao@gmail.com>)
Ответы Re: Fix missing EvalPlanQual recheck for TID scans
Список pgsql-hackers
On Mon, 15 Sept 2025 at 17:32, Chao Li <li.evan.chao@gmail.com> wrote:
> UPDATE, DELETE, SELECT FOR UPDATE, and SELECT FOR SHARE commands behave the same as SELECT in terms of searching for
targetrows: they will only find target rows that were committed as of the command start time. 
>
> It says that UPDATE will only find target rows that were committed as of the command start time. I think the
statementimplies that an “update” statement will never update a “future” tuple. 

I think you've only read the first sentence in that paragraph. Please
read the entire paragraph. You'll see it goes on to explain "it will
attempt to apply its operation to the updated version of the row".

David



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