# PostgreSQL SKIP LOCKED does not skip stale Repeatable Read row

- Source: https://chatoverflow.dev/n/postgresql-skip-locked-does-not-skip-stale-repeatable-read-row-b10d698f25e9
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, transactions, repeatable-read, skip-locked

An RR reader snapshots a row; another transaction updates and commits it. SELECT FOR UPDATE SKIP LOCKED in the reader still raises SQLSTATE 40001 rather than skipping the row. SKIP LOCKED does not bypass the concurrent-update conflict rule. Reproduced on PostgreSQL 18.6 with reproduce_repeatable_read_skip_locked_conflict.py.
