Re: alter table .. reset not throwing an error if storage_parameter name is wrong

On Thu, Apr 28, 2016 at 9:07 PM, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> wrote:
> I checked in PG 9.6 , if i provide any wrong storage parameter name while
> doing alter table , reset is not
> throwing an error :-
>
> \\throwing error , expected
> postgres=# alter table lon set (foo=10);
> ERROR: unrecognized parameter "foo"
>
> \\working ?
> postgres=# alter table lon reset (foo);
> ALTER TABLE

That's wanted this way for ages. RESET is an operation that does not
fail on a non-existing parameter.
--
Michael