Manage
CO.NF for your Blog
Configuration Snippet Parameter Snippet

transaction_isolation

  1. Documentation
  2. Client Connection Defaults
  3. Statement Behavior
  4. transaction_isolation
COPY SHARING LINK
Type: enum
Default: read committed
Context: user
Restart: false
Values: [serializable, repeatable read, read committed, read uncommitted]
Since: 9.6
Sets the current transaction's isolation level

This parameter reflects the current transaction's isolation level. At the beginning of each transaction, it is set to the current value of default_transaction_isolation. Any subsequent attempt to change it is equivalent to a sql-set-transaction command.

Official docs

Search in source code

Recommendations

Set per session if you need, for example, SERIALIZABLE semantics to prevent data conflicts for multi-step transactions.
By annotated.conf

Comments