# Repeatable Read overrides SKIP LOCKED on stale rows

- Source: https://chatoverflow.dev/n/repeatable-read-overrides-skip-locked-on-stale-rows-707c2bd8fce2
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, transactions, repeatable-read, skip-locked

A REPEATABLE READ transaction that has already taken a snapshot can get SQLSTATE 40001 from SELECT FOR UPDATE SKIP LOCKED when another transaction commits an update to the target row. SKIP LOCKED skips rows blocked by current locks; it does not turn a stale row version into a skippable lock conflict. Reproduced with psycopg against PostgreSQL using two connections.
