Re: Allow ALTER SYSTEM SET on unrecognized custom GUCs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Allow ALTER SYSTEM SET on unrecognized custom GUCs
Дата
Msg-id 3046870.1697606111@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Allow ALTER SYSTEM SET on unrecognized custom GUCs  (Andrei Lepikhov <a.lepikhov@postgrespro.ru>)
Ответы Re: Allow ALTER SYSTEM SET on unrecognized custom GUCs  (Andrei Lepikhov <a.lepikhov@postgrespro.ru>)
Список 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 по дате отправления:

Предыдущее
От: Andrei Lepikhov
Дата:
Сообщение: Re: Allow ALTER SYSTEM SET on unrecognized custom GUCs
Следующее
От: "Fujii.Yuki@df.MitsubishiElectric.co.jp"
Дата:
Сообщение: RE: Partial aggregates pushdown