Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2726: reindex database failed if number is in database name - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2726: reindex database failed if number is in database name
Date
Msg-id 9216.1162331597@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2726: reindex database failed if number is in database name  ("Ivan Volf" <insys@st.t-com.hr>)
List pgsql-bugs
Tree view 
"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

pgsql-bugs by date:

Previous
From: "Konstantin Pelepelin"
Date:
Subject: BUG #2727: pg_restore error on BLOB COMMENTS
Next
From: Jeff Davis
Date:
Subject: Re: COPY fails on 8.1 with invalid byte sequences in text