[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] alter table .. reset not throwing an error if storage_parameter name is wrong
From:       Michael Paquier <michael.paquier () gmail ! com>
Date:       2016-04-28 12:38:40
Message-ID: CAB7nPqQ_gkfNxHf2jdYZ6rLqT6ADkFkqnwh=4Y_Z1yfK+ifKJQ () mail ! gmail ! com
[Download RAW message or body]

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


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]