↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

transaction_isolation

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 SET TRANSACTION command.

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
transaction_isolation
short desc
Sets the current transaction's isolation level.
source
pg-settings-source-snapshot
unit
Unknown
vartype
enum

Definition PG 18

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 SET TRANSACTION command.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:f76d627593a91aa619a1c2ffa338dc4a204c59f2830cb5a77be2c6942deaf6da

Text language: en · wiki-repair-20261023:f76d627593a91aa619a1c2ffa338dc4a204c59f2830cb5a77be2c6942deaf6da