From: | William Garrison <postgres(at)mobydisk(dot)com> |
---|---|
To: | Postgres General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Error in ALTER DATABASE command |
Date: | 2008-09-23 15:49:18 |
Message-ID: | 48D90FFE.4080007@mobydisk.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
This does not happen if you create the database using a manual query in
pgadmin, or if you use psql. Both of those tools will create the
database as "mixedcase" instead of "MixedCase"
I am using:
"PostgreSQL 8.2.9 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"
I guess for now, I have to dump and reload my database. :(
Postgresql seems to force many things to lower case. Is it a bug that
the admin tool lets you create a database with mixed case names? Or is
it a bug that you cannot rename them thereafter?
From | Date | Subject | |
---|---|---|---|
Next Message | Douglas McNaught | 2008-09-23 15:55:16 | Re: Error in ALTER DATABASE command |
Previous Message | Phoenix Kiula | 2008-09-23 15:38:53 | Re: match an IP address |