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.
