Re: Problem with createdb & case (7.1.3)

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(dot)Elphick(at)lfix(dot)co(dot)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