Postgres Pro
Downloads
Home   >   mailing lists

Is this a bug? - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Is this a bug?
Date
Msg-id CAFcNs+qqAnt_g7Tr4Df-zPi+ybNXijDOU7eYtOJbZaGNQyE-Mw@mail.gmail.com
Whole thread Raw
Responses Re: Is this a bug?  (Robert Haas <robertmhaas@gmail.com>)
Re: Is this a bug?  (Euler Taveira <euler@timbira.com.br>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PATCH] Store Extension Options
Next
From: Greg Stark
Date:
Subject: Re: 9a57858f1103b89a5674f0d50c5fe1f756411df6