createdb buggy?

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

wsheldah@lexmark.com wrote:

Try typing
psql "THISDB"

$ psql "THISDB"
Connection to database 'thisdb' failed.
FATAL 1: Database thisdb does not exist in pg_database

Sorry, it doesn't work to

Jose

wsheldah@lexmark.com wrote:

Try typing
psql "THISDB"

Shouldn't this be

psql \"THISDB\"

so the shell doesn't strip the " off?

so that it won't convert your database name to lower case before it tries to
look it up in the system catalog.

--
Steve Wampler- SOLIS Project, National Solar Observatory
swampler@noao.edu

zammon@libero.it writes:

I'm using postgresql 6.5.3 and I think I found a bug in createdb tool.

Please upgrade to the latest stable release (7.1.3). I'm pretty sure the
behaviour you describe is fixed there.

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter

wsheldah@lexmark.com writes:

You also might want to upgrade to 7.1.3 or so
if possible; a lot has changed since 6.5.3.

Indeed. I get

$ psql THISDB
psql: FATAL 1: Database "THISDB" does not exist in the system catalog.

so recent versions of psql don't do the bogus case adjustment.

I believe we agreed awhile back that names typed on the Unix command
line should always be taken literally, not case-folded as they would
normally be within SQL commands. I'm not sure that we have fixed every
single script and program to adhere to that convention, but that's the
current plan.

regards, tom lane