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

Taught in

References