Обсуждение: Re: Proposal for Allow postgresql.conf values to be changed via SQL

On Mon, Oct 29, 2012 at 8:31 AM, Amit Kapila <amit.kapila@huawei.com> wrote:
> SYNTAX:
>
> ALTER SYSTEM SET configuration_parameter = value COMMENT 'value';
>

> Comments/Suggestions about the value of this feature and Implementation
> Idea?

How is this better than simply updating them through the pg_settings
view (in SQL)?

merlin

On Monday, October 29, 2012 7:06 PM Merlin Moncure wrote:
> On Mon, Oct 29, 2012 at 8:31 AM, Amit Kapila <amit.kapila@huawei.com>
> wrote:
> > SYNTAX:
> >
> > ALTER SYSTEM SET configuration_parameter = value COMMENT 'value';
> >
> 
> > Comments/Suggestions about the value of this feature and
> Implementation
> > Idea?
> 
> How is this better than simply updating them through the pg_settings
> view (in SQL)?

1. Comments cannot be given in pg_settings.
2. This is the syntax decided in the discussion last happened on this topic.
I am sorry, I should have mentioned the link of previous discussion in
proposal mail.
http://archives.postgresql.org/pgsql-hackers/2010-10/msg00764.php

With Regards,
Amit Kapila.