Wiki / Configuration Parameters
default_transaction_isolation
Each SQL transaction has an isolation level, which can be either “read uncommitted”, “read committed”, “repeatable read”, or “serializable”. This parameter controls the default isolation level of each new transaction. The default is “read committed”. Consult Chapter 13 and SET TRANSACTION for more information.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- boot val
- read committed
- category
- Client Connection Defaults / Statement Behavior
- context
- user
- documented
- true
- enumvals
- serializable, repeatable read, read committed, read uncommitted
- extra desc
- Unknown
- lang
- en
- max val
- Unknown
- metadata version
- 18
- min val
- Unknown
- name
- default_transaction_isolation
- short desc
- Sets the transaction isolation level of each new transaction.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- enum
Definition PG 18
Each SQL transaction has an isolation level, which can be either “read uncommitted”, “read committed”, “repeatable read”, or “serializable”. This parameter controls the default isolation level of each new transaction. The default is “read committed”. Consult Chapter 13 and SET TRANSACTION for more information.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:8f4b6b481ec37a85832c8ff5a234422dd35e4383d3fe1038e8ccd8aa1840a58c
Text language: en · wiki-repair-20261023:8f4b6b481ec37a85832c8ff5a234422dd35e4383d3fe1038e8ccd8aa1840a58c