From: Tom Lane <tgl@sss.pgh.pa.us>
To: m.kristo@rewe-group.at
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19043: jdbc connection url is not case insensitive
Date: Fri, 05 Sep 2025 17:20:06 -0400
Message-ID: <1529704.1757107206@sss.pgh.pa.us> (raw)
In-Reply-To: <19043-e6955a06c7befbf7@postgresql.org>
References: <19043-e6955a06c7befbf7@postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, m.kristo@rewe-group.at, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19043: jdbc connection url is not case insensitive
In-Reply-To: <1529704.1757107206@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox