repeatable read
An isolation level where a transaction keeps seeing the same snapshot of the data for its whole life.
In more detail
In PostgreSQL, if a row the transaction read is changed and committed by someone else, an attempt to update that row fails with a serialisation error. The application must then retry the whole transaction.
Related terms
- isolation level — A setting that controls how much concurrent transactions can see of each other's changes and how they may interleave.
- read committed — An isolation level where each statement sees only data committed before it began, never another transaction's unfinished changes.
- serializable — The strictest isolation level, which guarantees the result is the same as if transactions had run one after another.
Taught in
- Isolation Levels And The Lost Update — PostgreSQL, Indexing & Relational Data Modeling