William Garrison wrote:
In Postgresql 8.2.9 on Windows, you cannot rename a database if the
name contains mixed case.
To replicate:
1) Open the pgadmin tool.
2) Create a database named "MixedCase" (using the UI, not using a
query window or using PSQL)
3) Open a query window, or use PSQL to issue the following command
ALTER DATABASE MixedCase RENAME TO anything_else;
PostgreSQL will respond with:
ERROR: database "mixedcase" does not exist
SQL state: 3D000
Did you try:
ALTER DATABASE "MixedCase"....?
Note the use of double-quotes around the name. I don't have any Windows
machines to try this with but it appears you just need to add the
double-quotes to prevent PostgreSQL from folding to lower-case.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
