postgres transaction - ghdrako/doc_snipets GitHub Wiki

• READ COMMITTED Default transaction isolation level

BEGIN TRANSACTION ISOLATION LEVEL READ COMMITTED;

Multiple reads in the same transaction got different results

• REPEATABLE READ

BEGIN TRANSACTION ISOLATION LEVEL REPEATABLE READ;

• SERIALIZABLE

BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;

Concurrent changes should be blocked and for that we can use serialization isolation level