↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Configuration Parameters

transaction_deferrable

This parameter reflects the current transaction's deferrability status. At the beginning of each transaction, it is set to the current value of default_transaction_deferrable. 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
off
category
Client Connection Defaults / Statement Behavior
context
user
documented
true
enumvals
Unknown
extra desc
Unknown
lang
en
max val
Unknown
metadata version
18
min val
Unknown
name
transaction_deferrable
short desc
Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
source
pg-settings-source-snapshot
unit
Unknown
vartype
bool

Definition PG 18

This parameter reflects the current transaction's deferrability status. At the beginning of each transaction, it is set to the current value of default_transaction_deferrable. 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:8501c68db5ce755a81aa16afc69ed43edc46958e7d44b6fee48a0bf2f6485482

Text language: en · wiki-repair-20261023:8501c68db5ce755a81aa16afc69ed43edc46958e7d44b6fee48a0bf2f6485482