WIP: raise error when submitting invalid ALTER SYSTEM command - Mailing list pgsql-hackers

From Jordan Deitch
Subject WIP: raise error when submitting invalid ALTER SYSTEM command
Date
Msg-id a6ad7661-9b44-4e9c-923b-be1b25315023@www.fastmail.com
Whole thread Raw
Responses Re: WIP: raise error when submitting invalid ALTER SYSTEM command
List pgsql-hackers
Hi all,

ALTER SYSTEM currently does not raise error upon invalid entry. Take for example:

alter system set superuser_reserved_connections = 10;
> ALTER SYSTEM
alter system set max_connections = 5;
> ALTER SYSTEM

The database will now fail to restart without manual intervention by way of editing the autoconf file (which says "# Do
notedit this file manually!" on its first line).
 

The attached WIP patch is intended to raise an error on invalid ALTER SYSTEM commands before being written out to the
filesystem.Hopefully this behavior is more intuitive.
 

Thanks
--
Jordan Deitch
https://id.rsa.pub/
Attachment

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: format of pg_upgrade loadable_libraries warning
Next
From: Masahiko Sawada
Date:
Subject: Re: maintenance_work_mem used by Vacuum