diff options
| author | Fujii Masao <fujii@postgresql.org> | 2020-11-09 15:10:26 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2020-11-09 15:10:26 +0900 |
| commit | ef60de67ebde6dfd1ea09b4d08166736bf05698c (patch) | |
| tree | 2f31db3644789d48a568c5bd4d9891811bc69953 | |
| parent | 3636efa11945af64479995609762b2626c6c319a (diff) | |
| download | postgresql-ef60de67ebde6dfd1ea09b4d08166736bf05698c.tar.gz postgresql-ef60de67ebde6dfd1ea09b4d08166736bf05698c.zip | |
doc: Add note about pg_settings and customized options into catalogs.sgml.
The pg_settings view does not display customized options until
the extension module that defines them has been loaded. This commit
add the note about that behavior, into the docs.
Author: John Naylor
Reviewed-by: Tom Lane, Fujii Masao
Discussion: https://postgr.es/m/CAFBsxsGsBZsG=cLM0Op5HFb2Ks6SzJrOc_eRO_jcKSNuqFRKnQ@mail.gmail.com
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 5fb9dca4258..569841398b4 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -12279,10 +12279,14 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx </para> <para> - The <structname>pg_settings</structname> view cannot be inserted into or - deleted from, but it can be updated. An <command>UPDATE</command> applied - to a row of <structname>pg_settings</structname> is equivalent to executing - the <command>SET</command> command on that named + This view does not display <link linkend="runtime-config-custom">customized options</link> + until the extension module that defines them has been loaded. + </para> + + <para> + This view cannot be inserted into or deleted from, but it can be updated. An + <command>UPDATE</command> applied to a row of <structname>pg_settings</structname> + is equivalent to executing the <command>SET</command> command on that named parameter. The change only affects the value used by the current session. If an <command>UPDATE</command> is issued within a transaction that is later aborted, the effects of the <command>UPDATE</command> command |