Обсуждение: Problem with createdb & case (7.1.3)

Hi,

I'd like to create a database named "NEUROMR". The
command "createdb
NEUROMR" succeeds. But, connecting to this DB fails:

# psql "NEUROMR"
Connection to database 'neuromr' failed.
FATAL 1:  Database "neuromr" does not exist in the
system catalog.


Just to assure the DB exists I've executed "createdb
NEUROMR" a second
time and (as expected) got the message:

ERROR:  CREATE DATABASE: database "NEUROMR" already
exists
createdb: database creation failed


Does anybody out there have an explanation for this
behaviour? I'm using
PostgreSQL 7.1.3.


Thank you,

Christina Rossmanith

"Chr. Rossmanith" <cr@neuro.ma.uni-heidelberg.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

Hi

from the # prompt, it appears that you are already connected to some
database.

   #\c NEUROMR

should connect you to the new database.

Vijay

"Chr. Rossmanith" wrote:
>
> Hi,
>
> I'd like to create a database named "NEUROMR". The
> command "createdb
> NEUROMR" succeeds. But, connecting to this DB fails:
>
> # psql "NEUROMR"
> Connection to database 'neuromr' failed.
> FATAL 1:  Database "neuromr" does not exist in the

Vijay Deval wrote:
  >Hi
  >
  >from the # prompt, it appears that you are already connected to some
  >database.
  >
  >   #\c NEUROMR
  >
  >should connect you to the new database.

The # is the root prompt from Unix.  (It's not a good idea to run as root
if you don't have to.)

  >Vijay
  >
  >"Chr. Rossmanith" wrote:
  >>
  >> Hi,
  >>
  >> I'd like to create a database named "NEUROMR". The
  >> command "createdb
  >> NEUROMR" succeeds. But, connecting to this DB fails:
  >>
  >> # psql "NEUROMR"
  >> Connection to database 'neuromr' failed.
  >> FATAL 1:  Database "neuromr" does not exist in the

Your problem is that you have created a database with an uppercase name, but
psql is translating it to lowercase.  It probably means you are using an
older version of PostgreSQL, because this doesn't happen for me with 7.1.3.

I don't know how to tell psql from the command line not to do this, so
your best bet is to drop the database (dropdb NEUROMR) and recreate it with
a normal lowercase name.

If you _have_ to connect to NEUROMR, you could try this:

psql -d template1
\c NEUROMR

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "I press toward the mark for the prize of the high
      calling of God in Christ Jesus."
                                   Philippians 3:14

Hi,

thanks a lot for your responses to my question concerning psql and case.
The hint from Tom Lane was the best. There was an old psql which was
found first in the search path...what a stupid mistake. Now, when using
the correct psql everything works like expected...without any quotes.
(In my original posting I used quotes just to separate commands entered
from my question. I never entered a quoted psql command with options...)

Christina Rossmanith


Vijay Deval wrote:

> Hi
>
> from the # prompt, it appears that you are already connected to some
> database.
>
>    #\c NEUROMR
>
> should connect you to the new database.
>
> Vijay

No, this was just the root users prompt.

>
>
> "Chr. Rossmanith" wrote:
> >
> > Hi,
> >
> > I'd like to create a database named "NEUROMR". The
> > command "createdb
> > NEUROMR" succeeds. But, connecting to this DB fails:
> >
> > # psql "NEUROMR"
> > Connection to database 'neuromr' failed.
> > FATAL 1:  Database "neuromr" does not exist in the