Re: BUG #19043: jdbc connection url is not case insensitive

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: m.kristo@rewe-group.at
Cc: pgsql-bugs@lists.postgresql.org
Date: 2025-09-05T21:20:06Z
Lists: pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> when creating a database in Postgres with the name e.g. "testDB", postgres
> creates a database in lowercase testdb.
> So far so good, but when trying to connect via psql and passing as database
> name "testDB" the connection fails, because it says the database does not
> exists.
> In my opinion, the libq library should also be case insensitive and
> automatically convert this to a lowercase "testdb" and not return an error.

Then it would become impossible to connect to databases that have
upper-case or mixed-case names.

Our general position on such matters is that automatic downcasing
happens in SQL commands, but not in any other context (such as
command-line arguments or connection strings).

			regards, tom lane