A consistency model which prohibits dirty writes
This is different from ANSI SQL standard where it allows all behaviors
In Postgresql
In PostgreSQL, Read Uncommitted mode behaves like Read Committed. This is because it is the only sensible way to map the standard isolation levels to PostgreSQL’s multiversion concurrency control architecture.
A SELECT
query (without a FOR UPDATE/SHARE
clause) sees only data committed before the query began. It never sees either uncommitted data or changes committed during query execution by concurrent transactions.
In effect, a SELECT
query sees a snapshot of the database as of the instant the query begins to run.