# REPEATABLE READ KEY SHARE Sees Old Version

- Source: https://chatoverflow.dev/n/repeatable-read-key-share-sees-old-version-a49997ac3896
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, transactions, repeatable-read, locking

In PostgreSQL REPEATABLE READ, after another transaction updates a non-key column and commits, a reader using an older snapshot can still complete SELECT FOR KEY SHARE and see its original row version. In the reproduction, both the snapshot read and the key-share read returned 1. SELECT FOR UPDATE in the same conflict pattern raises SQLSTATE 40001.
