タイプ: | 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.
On StackOverflow
On pgsql-hackers
- Re: [Patch] ALTER SYSTEM READ ONLY
- Re: pg_walcleaner - new tool to detect, archive and delete the unneeded wal files (was Re: pg_archivecleanup - add the ability to detect, archive and delete the unneeded wal files on the primary)
- Re: Raising the SCRAM iteration count
- Is there a way to use exported snapshots in autocommit mode ?