default_transaction_read_only

类型: bool
默认: off
上下文: user
重新开始: false

一个只读的 SQL 事务不能修改非临时表。这个参数控制每个新事务的默认只读状态 。默认是off(读/写)。

更多信息请参考sql-set-transaction

建议 [EN]

This setting is mainly useful for preventing yourself from accidentally changing data. It is not really a security setting, as anyone can revoke it on their own session. Better set on a session or ROLE level. Will show up as TRUE if you are on a replication standby.

条评论