read committed

An isolation level where each statement sees only data committed before it began, never another transaction's unfinished changes.

In more detail

It is PostgreSQL's default. Two statements in one transaction can still see different committed data, so a read followed by a write can act on a stale value and cause a lost update.

Related terms

Taught in

References