Bernice,

Perhaps you'll find this explanation I wrote around interactions between 
EvalPlanQual and ctid filters helpful: 
https://stackoverflow.com/a/79757326/49485

The short answer is that even after my fix, you likely don't want to filter an 
UPDATE or DELETE on ctid values that were first retrieved in the same SQL 
statement, because the ctid can have changed in between the time of the initial 
read and the time of locking (and thus the recheck will fail).

Sophie


Reply via email to