Repeatable read

An isolation level where the whole transaction sees one consistent snapshot, so re-reading a row is stable. It removes non-repeatable reads; depending on the engine it may or may not remove phantoms, and it does not remove write skew. In PostgreSQL it is snapshot isolation and can abort your transaction with a serialisation failure you must be prepared to retry.