Re: another idea for changing global configuration settings from SQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: another idea for changing global configuration settings from SQL
Date
Msg-id 15226.1353080814@sss.pgh.pa.us
Whole thread Raw
In response to Re: another idea for changing global configuration settings from SQL  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: another idea for changing global configuration settings from SQL  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List 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 by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: gset updated patch
Next
From: Alvaro Herrera
Date:
Subject: Re: foreign key locks