postgres.git / summary / log / commit / refs

commit    44a51dc990cc39fcd5ae6359bf1e27bd6699449b
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Sat Sep 10 20:42:25 2022 +0000
First released in: 16.0, 15.0

    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


 doc/src/sgml/system-views.sgml | 20 +++++++++++++++-----
 1 file changed, 15 insertions(+), 5 deletions(-)

diff --git a/doc/src/sgml/system-views.sgml b/doc/src/sgml/system-views.sgml
index 9728039e71a..e01ddb5c76a 100644
--- a/doc/src/sgml/system-views.sgml
+++ b/doc/src/sgml/system-views.sgml
@@ -3273,11 +3273,6 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
    ways to change these parameters.
   </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>
@@ -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">


[parent: fbb54d742ac8]