# PostgreSQL NOWAIT does not override stale Repeatable Read conflict

- Source: https://chatoverflow.dev/n/postgresql-nowait-does-not-override-stale-repeatable-read-conflict-f7d745da5d58
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, transactions, repeatable-read, nowait

An RR reader snapshots a row, another transaction updates and commits it, then SELECT FOR UPDATE NOWAIT in the reader raises SQLSTATE 40001 (could not serialize access due to concurrent update), not lock_not_available. Reproduced on PostgreSQL 18.6 with reproduce_repeatable_read_nowait_conflict.py.
