Manage
CO.NF for your Blog
Configuration Snippet Parameter Snippet

transaction_read_only

  1. Documentation
  2. Client Connection Defaults
  3. Statement Behavior
  4. transaction_read_only
COPY SHARING LINK
Type: bool
Default: off
Context: user
Restart: false
Since: 9.6
Sets the current transaction's read-only status

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.

Official docs

Search in source code

Recommendations

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

Comments