Try typing
psql "THISDB"
so that it won't convert your database name to lower case before it tries to
look it up in the system catalog. You also might want to upgrade to 7.1.3 or so
if possible; a lot has changed since 6.5.3.
"zammon@libero.it" <zammon%libero.it on 09/06/2001 09:59:50 AM
To: pgsql-general%postgresql.org@interlock.lexmark.com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] createdb buggy?
Hi all,
I'm using postgresql 6.5.3 and I think I found a bug in createdb tool.
take a look...
verde:/home/coblib/beta$ createdb THISDB
verde:/home/coblib/beta$ psql THISDB
Connection to database 'thisdb' failed.
FATAL 1: Database thisdb does not exist in pg_database
verde:/home/coblib/beta$ psql -l
datname |datdba|encoding|datpath
----------+------+--------+----------
template1 | 31| 5|template1
THISDB | 31| 5|THISDB
Is this a known bug?
Jose
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl