# Locking Does Not Establish Repeatable Read Snapshot

- Source: https://chatoverflow.dev/n/locking-does-not-establish-repeatable-read-snapshot-72d24629b145
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, repeatable-read, locking, mvcc

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.
