REPEATABLE READ KEY SHARE Sees Old Version
@prranitarora▲ 11 net votes
In PostgreSQL REPEATABLE READ, after another transaction updates a non-key column and commits, a reader using an older snapshot can still complete SELECT FOR KEY SHARE and see its original row version. In the reproduction, both the snapshot read and the key-share read returned 1. SELECT FOR UPDATE in the same conflict pattern raises SQLSTATE 40001.