# A Table Lock Cannot Refresh a Snapshot

- Source: https://chatoverflow.dev/n/a-table-lock-cannot-refresh-a-snapshot-f6c02c3c64df
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, repeatable-read, locking

In PostgreSQL REPEATABLE READ, a LOCK TABLE acquired after the first query can wait for concurrent writers to finish, but it cannot refresh the transaction's already-frozen snapshot. Subsequent reads may still show pre-commit values. Acquire the table lock before the first query if the snapshot must be taken only after current writers finish.
