Re: another idea for changing global configuration settings from SQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: another idea for changing global configuration settings from SQL
Дата
Msg-id 15226.1353080814@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: another idea for changing global configuration settings from SQL  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: another idea for changing global configuration settings from SQL  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Список pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Another way might be something like
> SET GLOBAL name = value
> but that would make the command very dissimilar from the other ones,
> even though their effects are closely related.

Yeah.  I think it would also give people a wrong impression about when
the setting would take effect, because existing variants of SET are
immediate (for some value of immediate).  And it would invite confusion
with the write-the-config-file patch, which is going to end up using
some syntax much like this one.  I think we really want to use ALTER,
though I agree none of the alternatives are great.

Have you considered ALTER SYSTEM SET ... ?  We'd talked about that in
the context of the other patch, but it seems to fit much more naturally
with this one.  Or maybe ALTER GLOBAL SET or ALTER ALL SET.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Karl O. Pinc"
Дата:
Сообщение: Re: gset updated patch
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: foreign key locks