Bug #435: Cannot connect to databases if using Capital Letters - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #435: Cannot connect to databases if using Capital Letters
Date
Msg-id 200108311518.f7VFIZk50203@hub.org
Whole thread Raw
Responses Re: Bug #435: Cannot connect to databases if using Capital
List pgsql-bugs
James Pattie (james@pcxperience.com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Cannot connect to databases if using Capital Letters

Long Description
If I create a database Ex. BUGS it shows up as bugs instead of BUGS.
I can drop the database by saying "drop database BUGS;" and it works
but I can not do a \c BUGS or psql BUGS.  I get this error:
psql: FATAL 1:  Database "BUGS" does not exist in the system catalog.

Is this a bug or a feature?  It appears like the connect code is not
lowercasing the database name like it appears to do in the create and
drop cases.

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Andrew MacFarlane
Date:
Subject: problem with \d {tablename}
Next
From: Peter Eisentraut
Date:
Subject: Re: problem with \d {tablename}