Bug #435: Cannot connect to databases if using Capital Letters

Started by PostgreSQL Bugs Listover 24 years ago3 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

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

#2Peter Eisentraut
peter_e@gmx.net
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #435: Cannot connect to databases if using Capital

James Pattie (james@pcxperience.com) reports a bug with a severity of 3

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.

Will be fixed.

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

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Peter Eisentraut (#2)
Re: Bug #435: Cannot connect to databases if using Capital

Peter Eisentraut writes:

James Pattie (james@pcxperience.com) reports a bug with a severity of 3

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.

Will be fixed.

Fixed now in CVS tip.

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