--- On Tue, 9/23/08, William Garrison <[EMAIL PROTECTED]> wrote:
> From: William Garrison <[EMAIL PROTECTED]>
> Subject: [GENERAL] Error in ALTER DATABASE command
> To: "Postgres General List"
> Date: Tuesday, September 23, 2008, 3:49 PM
> In Postgresql
I found out about the quoting thing about 30 seconds after I made the
post. :) Thanks everyone who replied.
Douglas McNaught wrote:
On Tue, Sep 23, 2008 at 11:49 AM, William Garrison
<[EMAIL PROTECTED]> wrote:
In Postgresql 8.2.9 on Windows, you cannot rename a database if the name
contain
On 23/09/2008 16:49, William Garrison wrote:
> In Postgresql 8.2.9 on Windows, you cannot rename a database
> if the name contains mixed case.
Yes you can, in 8.3 anyway:
postgres=# create database "TeSt";
CREATE DATABASE
postgres=# \l
List of databases
Name | Owner |
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 is
On Tue, Sep 23, 2008 at 11:49 AM, William Garrison
<[EMAIL PROTECTED]> wrote:
> In Postgresql 8.2.9 on Windows, you cannot rename a database if the name
> contains mixed case.
> 3) Open a query window, or use PSQL to issue the following command
> ALTER DATABASE MixedCase RENAME TO anything_else;
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
