Skip site navigation (1) Skip section navigation (2)

Re: BUG #2726: reindex database failed if number is in database name

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ivan Volf" <insys(at)st(dot)t-com(dot)hr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2726: reindex database failed if number is in database name
Date: 2006-10-31 21:53:17
Message-ID: 9216.1162331597@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Ivan Volf" <insys(at)st(dot)t-com(dot)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

In response to

pgsql-bugs by date

Next:From: Jeff DavisDate: 2006-10-31 22:15:10
Subject: Re: COPY fails on 8.1 with invalid byte sequences in text
Previous:From: Tom LaneDate: 2006-10-31 21:13:24
Subject: Re: COPY fails on 8.1 with invalid byte sequences in text

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group