Re: document pg_settings view doesn't display custom options

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: John Naylor <john(dot)naylor(at)enterprisedb(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: document pg_settings view doesn't display custom options
Date: 2020-10-30 03:50:59
Message-ID: 80d62828-77d0-ec35-43db-3b1038fea7ee@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2020/10/29 21:54, John Naylor wrote:
>
>
> On Wed, Oct 28, 2020 at 11:38 PM Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com <mailto:masao(dot)fujii(at)oss(dot)nttdata(dot)com>> wrote:
>
>
>
> On 2020/10/29 3:45, John Naylor wrote:
> > On Wed, Oct 28, 2020 at 2:15 PM John Naylor <john(dot)naylor(at)enterprisedb(dot)com <mailto:john(dot)naylor(at)enterprisedb(dot)com> <mailto:john(dot)naylor(at)enterprisedb(dot)com <mailto:john(dot)naylor(at)enterprisedb(dot)com>>> wrote:
> >
> >     Starting separate threads to keep from cluttering the TODO list thread.
> >
> >     Here's a patch for the subject, as mentioned in
> > https://www.postgresql.org/message-id/20201027220555.GS4951%40momjian.us
> >
> >
> > I just realized I introduced a typo, so here's v2.
>
> +   The <structname>pg_settings</structname> view does not display
> +   <link linkend="runtime-config-custom">customized options</link>.
>
> This is true until the module that defines the customized options is loaded,
> but not after that. No? For example, pg_settings displays
> pg_stat_statements.max after pg_stat_statements is loaded.
>
>
> True, how about this:
>
>    The <structname>pg_settings</structname> does not display
>    <link linkend="runtime-config-custom">customized options</link>
>    that have been set before the relevant extension module has been loaded.

I guess that someone can misread this as

customized options that have been set before the relevant extension
module has been loaded are not displayed even after the module is loaded.

So what about the following, instead?

The pg_settings does not display customized options until the extension
module that defines them has been loaded.

Also I think this note should be in the different paragraph from the paragraph
of "The pg_settings view cannot be inserted into or deleted from...." because
they are different topics. Thought?

Regards,

--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Julien Rouhaud 2020-10-30 03:58:13 Re: Online checksums verification in the backend
Previous Message Amit Kapila 2020-10-30 03:47:00 Re: Enumize logical replication message actions