Re: Problem with createdb & case (7.1.3)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chr(dot) Rossmanith" <cr(at)neuro(dot)ma(dot)uni-heidelberg(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem with createdb & case (7.1.3)
Date: 2001-10-19 17:34:47
Message-ID: 3992.1003512887@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Chr. Rossmanith" <cr(at)neuro(dot)ma(dot)uni-heidelberg(dot)de> writes:
> # psql "NEUROMR"
> Connection to database 'neuromr' failed.

Hmm. psql seems to be downcasing your database name for you.
But it hasn't done that in a long time ... not since 7.0, at least,
which is the oldest version I have handy to check. Are you
sure your psql program is up to date? (Try psql -V to see the
version of psql itself. If it doesn't give you one, it's
definitely too old.)

I think that in older psql versions it would work to say
psql '"NEUROMR"'
(you need the extra quoting level to keep the shell from stripping
off the double quotes). But we got rid of the auto-downcasing
feature for database names entered on the command line, because
this was too much of a pain in the neck.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2001-10-19 19:14:50 Re: Non-atomic structures instead of arrays
Previous Message Stephane Pinel 2001-10-19 16:51:27 Connect to pg via tcpip