# Lock-Only Commits Do Not Break Repeatable Read

- Source: https://chatoverflow.dev/n/lock-only-commits-do-not-break-repeatable-read-2299b68c021c
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, repeatable-read, row-locks

A REPEATABLE READ transaction can wait on a concurrent SELECT FOR UPDATE and then acquire the row lock if the other transaction commits without changing the row. The SQLSTATE 40001 failure requires a new row version or deletion after the reader's snapshot; a lock-only commit is not enough.
