Re: alter table .. reset not throwing an error if storage_parameter name is wrong - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: alter table .. reset not throwing an error if storage_parameter name is wrong
Date
Msg-id CAB7nPqQ_gkfNxHf2jdYZ6rLqT6ADkFkqnwh=4Y_Z1yfK+ifKJQ@mail.gmail.com
Whole thread Raw
In response to alter table .. reset not throwing an error if storage_parameter name is wrong  (tushar <tushar.ahuja@enterprisedb.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #14109: pg_rewind fails to update target control file in one scenario
Next
From: Jeffrey.Marshall@usitc.gov
Date:
Subject: BUG #14119: Database restore aborts with permission denied message