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

On Fri, Jul 4, 2014 at 11:24 AM, Mark Kirkwood <
mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> wrote:
> 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.

Sure, as suggested upthread, I think we can add a note so that
users can atleast aware of such a behaviour for now and for 9.5,
I will try to see if I can eliminate this problem.

> 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.

Good to hear.

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com