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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs