Thread: 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