Обсуждение: mixed case database name

Hi-

I have a database with a mixed upper/lower case name (eg. "testA").
When I try to create a new database using this database as a template,
pgAdmin responds with "ERROR! Template database testa does not exist." I can create a new database using the command
line:> createdb -T
 
"testA" newdb.  So it seems to me a very simple fix to throw quotes
around the template database name when pgAdmin executes the command. As far as I can tell, pgAdmin has no other
problemswith mixed-case
 
database names.

Matt

Sorry. Forgot to mention that I'm using PgAdminIII 1.1.0 Developer's
version (Feb 11 2004) on Win2K.

>-----Original Message-----
>From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-
>owner@postgresql.org] On Behalf Of Matt Doggett
>Sent: Friday, March 05, 2004 9:00 AM
>To: pgadmin-support@postgresql.org
>Subject: [pgadmin-support] mixed case database name
>
>Hi-
>
>I have a database with a mixed upper/lower case name (eg. "testA").
>When I try to create a new database using this database as a template,
>pgAdmin responds with "ERROR! Template database testa does not exist."
>  I can create a new database using the command line :> createdb -T
>"testA" newdb.  So it seems to me a very simple fix to throw quotes
>around the template database name when pgAdmin executes the command.
>  As far as I can tell, pgAdmin has no other problems with mixed-case
>database names.
>
>Matt
>
>
>
>---------------------------(end of
broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)

Matt Doggett wrote:

>Hi-
>
>I have a database with a mixed upper/lower case name (eg. "testA").
>When I try to create a new database using this database as a template,
>pgAdmin responds with "ERROR! Template database testa does not exist."
>  I can create a new database using the command line :> createdb -T
>"testA" newdb.  So it seems to me a very simple fix to throw quotes
>around the template database name when pgAdmin executes the command.
>  As far as I can tell, pgAdmin has no other problems with mixed-case
>database names.
>  
>
Hi Matt,

thanks for reporting. Fixed in cvs for head and stable.

I uploaded a new win32 snapshot.

Regards,
Andreas