Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit834ef11

Browse files
tglsfdcpull[bot]
authored andcommitted
Doc: improve explanation of when custom GUCs appear in pg_settings.
Be more clear about when and how an extension-defined GUC comes to bevisible in pg_settings. (Move the para to the bottom of the page, too;whoever thought this point was more important than the para about theview being updatable had odd priorities IMNSHO.)Back-patch to v15 where archive modules were added, since that seemsto have made this more of a sore spot than it was before.Benoit Lobréau, Nathan BossartDiscussion:https://postgr.es/m/CAPE8EZ7KHaXMHKwT=HOim23tDVKYA1PruRuTfeYdCrYWwPGhag@mail.gmail.com
1 parentbe92207 commit834ef11

File tree

1 file changed

+15
-5
lines changed

1 file changed

+15
-5
lines changed

‎doc/src/sgml/system-views.sgml

Lines changed: 15 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -3273,11 +3273,6 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
32733273
ways to change these parameters.
32743274
</para>
32753275

3276-
<para>
3277-
This view does not display <link linkend="runtime-config-custom">customized options</link>
3278-
until the extension module that defines them has been loaded.
3279-
</para>
3280-
32813276
<para>
32823277
This view cannot be inserted into or deleted from, but it can be updated. An
32833278
<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
32913286
<command>SET</command>.
32923287
</para>
32933288

3289+
<para>
3290+
This view does not
3291+
display <link linkend="runtime-config-custom">customized options</link>
3292+
unless the extension module that defines them has been loaded by the
3293+
backend process executing the query (e.g., via a mention in
3294+
<xref linkend="guc-shared-preload-libraries"/>,
3295+
a call to a C function in the extension, or the
3296+
<link linkend="sql-load"><command>LOAD</command></link> command).
3297+
For example, since <link linkend="archive-modules">archive modules</link>
3298+
are normally loaded only by the archiver process not regular sessions,
3299+
this view will not display any customized options defined by such modules
3300+
unless special action is taken to load them into the backend process
3301+
executing the query.
3302+
</para>
3303+
32943304
</sect1>
32953305

32963306
<sect1 id="view-pg-shadow">

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp