Re: Proposal for Allow postgresql.conf values to be changed via SQL [review] - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]
Date
Msg-id 004f01ce6d68$e4e6f250$aeb4d6f0$@kapila@huawei.com
Whole thread Raw
In response to Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Wednesday, June 19, 2013 11:30 PM Peter Eisentraut wrote:
> On 6/7/13 12:14 AM, Amit Kapila wrote:
> > I will change the patch as per below syntax if there are no
> objections:
> >
> >  ALTER SYSTEM SET configuration_parameter {TO | =} {value, |
> 'value'};
> 
> I do like using ALTER SYSTEM in general, but now that I think about it,
> the 9.3 feature to create global settings in pg_db_role_setting would
> also have been a candidate for exactly that same syntax if it had been
> available.  In fact, if we do add ALTER SYSTEM, it might make sense to
> recast that feature into that syntax.
> 
> It might be clearer to do something like ALTER SYSTEM SET EXTERNAL FILE
> or something like that.  It's only a small syntax change, so don't
> worry
> about it too much, but let's keep thinking about it.

Is your intention to extend the syntax by EXTERNAL FILE is for specifying
SCOPE for configuration parameter?

ALTER SYSTEM SET SCOPE FILE
ALTER SYSTEM SET EXTENSION FILE


With Regards,
Amit Kapila.




pgsql-hackers by date:

Previous
From: fabriziomello
Date:
Subject: Re: [PATCH] add long options to pgbench (submission 1)
Next
From: Amit Kapila
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])