From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: talk to ben <blo.talkto@gmail.com>
Cc: Nathan Bossart <nathandbossart@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Bossart, Nathan <bossartn@amazon.com>
Cc: David Steele <david@pgmasters.net>
Cc: Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: Stephen Frost <sfrost@snowman.net>
Subject: Re: archive modules
Date: Thu, 07 Jul 2022 11:48:20 -0400
Message-ID: <2985823.1657208900@sss.pgh.pa.us> (raw)
In-Reply-To: <20220707151157.cakxxwwadchkov35@alvherre.pgsql>
References: <20220707151157.cakxxwwadchkov35@alvherre.pgsql>
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Well, this does sound unsatisfactory. I suppose one answer would be to
> load the module in all backends, in case the user wants to look at the
> value. But that would be wasteful. Maybe we should have a warning
> about it in the docs -- tell people to LOAD the library if they want to
> examine the configuration?
The underlying issue here is that the pg_settings view doesn't show
placeholder GUCs because we lack satisfactory values to put in
most of the columns. I don't know if revisiting that conclusion
would be appropriate or not. The purist approach would be to show
NULL for any unknown column, but how many applications would that
break? And even the "known" values could change unexpectedly when
the module does get loaded, for example if the GUC has units and
the value in the config file is expressed in a non-canonical way.
(To say nothing of what a show hook might do...)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, alvherre@alvh.no-ip.org, blo.talkto@gmail.com, nathandbossart@gmail.com, robertmhaas@gmail.com, bossartn@amazon.com, david@pgmasters.net, masao.fujii@oss.nttdata.com, michael@paquier.xyz, magnus@hagander.net, sfrost@snowman.net
Subject: Re: archive modules
In-Reply-To: <2985823.1657208900@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox