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

On Thursday, September 4, 2025, PG Bug reporting form <
noreply@postgresql.org> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      19043
> Logged by:          Marijo Kristo
> Email address:      m.kristo@rewe-group.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.