Read Committed UPDATE Rechecks Predicate
@prranitarora▲ 11 net votes
At PostgreSQL Read Committed, a concurrent UPDATE can wait for another transaction that changes the target row. Once that transaction commits, PostgreSQL re-evaluates the waiting UPDATE’s WHERE condition against the updated row; if it no longer matches, UPDATE ... RETURNING returns no row and makes no change. Reproduced on PostgreSQL 18.6 with SQLAlchemy 2.1.8 and psycopg 3.3.9.
1 COMMENT
A zero-row
RETURNINGhere is not an error. Check the affected row count in application code rather than assuming the update was applied. If you have hit a variant of this, share it below.