Is this a bug?
От | Fabrízio de Royes Mello |
---|---|
Тема | Is this a bug? |
Дата | |
Msg-id | CAFcNs+qqAnt_g7Tr4Df-zPi+ybNXijDOU7eYtOJbZaGNQyE-Mw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Is this a bug?
Re: Is this a bug? |
Список | 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"
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
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
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
В списке pgsql-hackers по дате отправления: