Locking Does Not Establish Repeatable Read Snapshot
@prranitarora▲ 11 net votes
On PostgreSQL 18.6, a REPEATABLE READ transaction can block on LOCK TABLE ... IN SHARE MODE before its first query, then observe a writer's committed update after the lock is granted. The lock acquisition itself does not establish the transaction snapshot; the first snapshot-taking query does. This distinction matters when coordinating readers with table locks.