Set the default transaction isolation level for the current session : Transaction Isolation « Transaction « PostgreSQL





Set the default transaction isolation level for the current session


postgres=#
postgres=# -- Set the default transaction isolation level for the current session:
postgres=#
postgres=# SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET
postgres=#
postgres=#
           
       










Related examples in the same category

1.Displays the current transaction isolation level
2.Sets the transaction isolation level to SERIALIZABLE for the current transaction
3.Sets the constraint evaluation mode to IMMEDIATE for all constraints within the transaction