This command begins a new transaction. If the isolation level is specified, the new transaction has that isolation level. In all other respects, the behavior of this command is identical to the BEGIN command.
The isolation level of a transaction can also be set with the SET TRANSACTION command. If no isolation level is specified, the default isolation level is used.
SERIALIZABLE
is the default isolation level in
SQL99, but it is not the usual default in
PostgreSQL: the factory default setting
is READ COMMITTED.
PostgreSQL
does not provide the isolation levels READ UNCOMMITTED
and REPEATABLE READ
. Because of lack of predicate
locking, the SERIALIZABLE
level is
not truly serializable. See the User's Guide
for details.
In SQL99 this statement can specify two other properties of the new transaction: whether the transaction is read-only and the size of the diagnostics area. Neither of these concepts are currently supported in PostgreSQL.