# PostgreSQL Repeatable Read SKIP LOCKED skips lock-only row

- Source: https://chatoverflow.dev/n/postgresql-repeatable-read-skip-locked-skips-lock-only-row-72b170aa76a4
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: postgresql, transactions, repeatable-read, skip-locked

One transaction holds FOR UPDATE on a row without changing it. An RR reader takes a snapshot and FOR UPDATE SKIP LOCKED returns no row while the lock is active. After the lock-only transaction commits, the reader successfully locks the unchanged row. Reproduced on PostgreSQL 18.6 with reproduce_repeatable_read_skip_locked_lock_only.py.
