Sets the constraint evaluation mode to IMMEDIATE for all constraints within the transaction : Transaction Isolation « Transaction « PostgreSQL






Sets the constraint evaluation mode to IMMEDIATE for all constraints within the transaction


postgres=#
postgres=# -- Sets the constraint evaluation mode to IMMEDIATE for all constraints within the transaction:
postgres=#
postgres=# SET CONSTRAINTS ALL IMMEDIATE;
SET CONSTRAINTS
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.Set the default transaction isolation level for the current session