From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
---|---|
To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Is this a bug? |
Date: | 2014-03-13 03:11:21 |
Message-ID: | CAFcNs+qqAnt_g7Tr4Df-zPi+ybNXijDOU7eYtOJbZaGNQyE-Mw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi all,
Shouldn't the "ALTER" statements below raise an exception?
fabrizio=# CREATE TABLE foo(bar SERIAL PRIMARY KEY);
CREATE TABLE
fabrizio=# SELECT relname, reloptions FROM pg_class WHERE relname ~ '^foo';
relname | reloptions
-------------+------------
foo |
foo_bar_seq |
foo_pkey |
(3 rows)
fabrizio=# ALTER TABLE foo RESET (noname);
ALTER TABLE
fabrizio=# ALTER INDEX foo_pkey RESET (noname);
ALTER INDEX
fabrizio=# ALTER TABLE foo ALTER COLUMN bar RESET (noname);
ALTER TABLE
If I try to "SET" an option called "noname" obviously will raise an
exception:
fabrizio=# ALTER TABLE foo SET (noname=1);
ERROR: unrecognized parameter "noname"
fabrizio=# ALTER INDEX foo_pkey SET (noname=1);
ERROR: unrecognized parameter "noname"
fabrizio=# ALTER TABLE foo ALTER COLUMN bar SET (noname=1);
ERROR: unrecognized parameter "noname"
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2014-03-13 03:51:42 | Re: 9a57858f1103b89a5674f0d50c5fe1f756411df6 |
Previous Message | Robert Haas | 2014-03-13 02:14:06 | Re: [PATCH] Store Extension Options |