Обсуждение: BUG #2726: reindex database failed if number is in database name

The following bug has been logged online:

Bug reference:      2726
Logged by:          Ivan Volf
Email address:      insys@st.t-com.hr
PostgreSQL version: 8.1
Operating system:   linux
Description:        reindex database failed if number is in database name
Details:

drin=# reindex database test;
NOTICE:  table "pg_class" was reindexed
NOTICE:  table "sql_features" was reindexed
NOTICE:  table "sql_implementation_info" was reindexed
NOTICE:  table "sql_languages" was reindexed

drin=# reindex database 06test;
ERROR:  syntax error kod ili u blizini "06" at character 18
LINE 1: reindex database 06test;

"Ivan Volf" <insys@st.t-com.hr> writes:
> drin=# reindex database 06test;
> ERROR:  syntax error kod ili u blizini "06" at character 18

This isn't a bug.  If you want to use names that aren't ordinary
identifiers, you need to double-quote them.

            regards, tom lane