Обсуждение: alter table .. reset not throwing an error if storage_parameter name is wrong

Hi,

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

--
regards,tushar

On Thu, Apr 28, 2016 at 9:07 PM, tushar <tushar.ahuja@enterprisedb.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