From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | depesz(at)depesz(dot)com |
Cc: | pgsql-general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to I select value of GUC that has - in its name? |
Date: | 2021-02-09 15:50:23 |
Message-ID: | 0564844d-4dda-9162-13b5-4c95c4340e95@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2/9/21 7:45 AM, hubert depesz lubaczewski wrote:
> On Tue, Feb 09, 2021 at 07:41:02AM -0800, Adrian Klaver wrote:
>> The only way I found so far is:
>> select setconfig[array_position(setconfig, 'custom.bad-guc=1a')] from
>> pg_db_role_setting where setrole = 'aklaver'::regrole;
>
> Yeah, but this will require some parsing if I don't know what the value
> is.
> Of course, it's not impossible, I can:
> with x as (
> select unnest(setconfig) as u
> from pg_db_role_setting
> where setrole = 'depesz'::regrole
> )
> select regexp_replace(u, '^[^=]*=', '') from x where u like 'custom.bad-guc=%';
>
> but I find it curious that I can set the guc using normal-ish SET, but
> can't get it using SHOW or even select current_setting()
Yeah, I think that part is a bug report.
>
> depesz
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Thorsten Schöning | 2021-02-09 15:52:02 | How does Postgres decide if to use additional workers? |
Previous Message | hubert depesz lubaczewski | 2021-02-09 15:45:03 | Re: How to I select value of GUC that has - in its name? |