postgres-errors-serialization
Installation
SKILL.md
postgres-errors-serialization
Quick Reference :
PostgreSQL has three usable isolation levels. READ UNCOMMITTED is accepted by
the parser but behaves exactly like READ COMMITTED. There is no dirty-read
mode.
| Level | Snapshot scope | Prevents | Still allows |
|---|---|---|---|
READ COMMITTED (default) |
per statement | dirty reads | nonrepeatable reads, phantom reads, write skew |
REPEATABLE READ |
per transaction | dirty + nonrepeatable + phantom reads | write skew (serialization anomalies) |
SERIALIZABLE |
per transaction + SSI | everything, including write skew | nothing |
A transaction running at REPEATABLE READ or SERIALIZABLE can fail with :