Re: Allow ALTER SYSTEM SET on unrecognized custom GUCs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Allow ALTER SYSTEM SET on unrecognized custom GUCs
Date
Msg-id 3046870.1697606111@sss.pgh.pa.us
Whole thread Raw
In response to Re: Allow ALTER SYSTEM SET on unrecognized custom GUCs  (Andrei Lepikhov <a.lepikhov@postgrespro.ru>)
Responses Re: Allow ALTER SYSTEM SET on unrecognized custom GUCs
List pgsql-hackers
Andrei Lepikhov <a.lepikhov@postgrespro.ru> writes:
> "SET foo.bar TO 'smth'" can immediately alter the placeholder's value. 
> But what is the reason that "ALTER SYSTEM SET foo.bar TO 'smth'" doesn't 
> do the same?

Because it's not supposed to take effect until you issue a reload
command (and maybe not even then, depending on which GUC we're
talking about).  I certainly think it wouldn't make sense for your
own session to adopt the value ahead of others.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andrei Lepikhov
Date:
Subject: Re: Allow ALTER SYSTEM SET on unrecognized custom GUCs
Next
From: "Fujii.Yuki@df.MitsubishiElectric.co.jp"
Date:
Subject: RE: Partial aggregates pushdown