Re: Alter system and reload causes bogus complaints about setting changes

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Alter system and reload causes bogus complaints about setting changes
Date: 2014-07-04 05:54:40
Message-ID: 53B641A0.3030603@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 04/07/14 15:11, Amit Kapila wrote:
>
> True, but as I explained in that thread as well that this is an
> existing behaviour which is also visible via Alter System, so
> changing an existing mechanism requires non-trivial fix (eliminating
> duplicate entries during processing of config file) which I think
> can be risky doing at this time in terms of impact, however we
> can try to minimise the inconvenience user can face due to this feature.
>

However the existence of ALTER SYSTEM has made the likelihood of this
error much more likely, and also more confusing. Previously users *knew*
they were editing an additional include conf file or similar so the
advice 'eliminate clashes' was fine - the new functionality hides this
(which is great) but obfuscates the error and makes the error message
wrong (not so good). So some additional clarification is really required.

I have just had a similar conversation with some people here about ALTER
SYSTEM in 9.4 - they *loved* the feature, but were bemused (at the very
least) by the error message.

Regards

Mark

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2014-07-04 06:31:42 Re: Alter system and reload causes bogus complaints about setting changes
Previous Message Mark Kirkwood 2014-07-04 05:35:50 Re: Alter system and reload causes bogus complaints about setting changes