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

On Thursday, September 4, 2025, PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 19043
> Logged by: Marijo Kristo
> Email address: m(dot)kristo(at)rewe-group(dot)at
> PostgreSQL version: 17.6
> Operating system: Linux
> Description:
>
> Hello,
>
> 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.
>
> What are your thoughts ?
>

Most/All usages of identifiers outside of an SQL Command identifier do not
result in case-folding. And besides, changing any that do is a breaking
change that we are unlikely to accept.

David J.