Type: bool
Default: off
Context: user
Restart: false
Since: 9.6

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


Sets the current transaction to read only. Useful as part of a SQL injection prevention program. Shows as TRUE on replication standbys.