| Lists: | pgsql-hackers |
|---|
| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila(at)huawei(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Proposal for Allow postgresql.conf values to be changed via SQL |
| Date: | 2012-10-29 13:36:16 |
| Message-ID: | CAHyXU0yBceY5YCoQ32krx5G_bwscAP9wEF1_u6kqd5ud6nbaSw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Mon, Oct 29, 2012 at 8:31 AM, Amit Kapila <amit(dot)kapila(at)huawei(dot)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
| From: | Amit Kapila <amit(dot)kapila(at)huawei(dot)com> |
|---|---|
| To: | "'Merlin Moncure'" <mmoncure(at)gmail(dot)com> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Proposal for Allow postgresql.conf values to be changed via SQL |
| Date: | 2012-10-29 14:06:08 |
| Message-ID: | 008501cdb5de$8bbd7970$a3386c50$@kapila@huawei.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Monday, October 29, 2012 7:06 PM Merlin Moncure wrote:
> On Mon, Oct 29, 2012 at 8:31 AM, Amit Kapila <amit(dot)kapila(at)huawei(dot)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.