diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2022-09-10 16:42:24 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2022-09-10 16:42:24 -0400 |
| commit | 857808a4116b231822746d6e70ded27bff0ec612 (patch) | |
| tree | e6b5428bf3bcb44b28dd30b65de688e4ce47c319 /doc/src | |
| parent | 6afcab6ac1e03975dc59d62c3ccaf98ed2831669 (diff) | |
| download | postgresql-857808a4116b231822746d6e70ded27bff0ec612.tar.gz | |
Doc: improve explanation of when custom GUCs appear in pg_settings.
Be more clear about when and how an extension-defined GUC comes to be
visible in pg_settings. (Move the para to the bottom of the page, too;
whoever thought this point was more important than the para about the
view being updatable had odd priorities IMNSHO.)
Back-patch to v15 where archive modules were added, since that seems
to have made this more of a sore spot than it was before.
Benoit Lobréau, Nathan Bossart
Discussion: https://postgr.es/m/CAPE8EZ7KHaXMHKwT=HOim23tDVKYA1PruRuTfeYdCrYWwPGhag@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/system-views.sgml | 20 |
1 files changed, 15 insertions, 5 deletions
diff --git a/doc/src/sgml/system-views.sgml b/doc/src/sgml/system-views.sgml index 44aa70a031..3f573a4f08 100644 --- a/doc/src/sgml/system-views.sgml +++ b/doc/src/sgml/system-views.sgml @@ -3274,11 +3274,6 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx </para> <para> - 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 @@ -3291,6 +3286,21 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <command>SET</command>. </para> + <para> + This view does not + display <link linkend="runtime-config-custom">customized options</link> + unless the extension module that defines them has been loaded by the + backend process executing the query (e.g., via a mention in + <xref linkend="guc-shared-preload-libraries"/>, + a call to a C function in the extension, or the + <link linkend="sql-load"><command>LOAD</command></link> command). + For example, since <link linkend="archive-modules">archive modules</link> + are normally loaded only by the archiver process not regular sessions, + this view will not display any customized options defined by such modules + unless special action is taken to load them into the backend process + executing the query. + </para> + </sect1> <sect1 id="view-pg-shadow"> |