pgjdbc/pgjdbc GitHub issues and pull requests (mirror)
help / color / mirror / Atom feedFrom: davecramer (@davecramer) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: Re: [pgjdbc/pgjdbc] issue #3722: spring jdbc causes problems with uppercase db names since 42.7.5
Date: Thu, 31 Jul 2025 10:11:53 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
Sorry for my late reply.
As to the change being in a minor release. It's somewhat fuzzy. We considered it a bug as we were just fixing it to adhere to the spec.
As to storesLowerCaseIdentifiers: This is what the javadoc says:
```
boolean | storesLowerCaseIdentifiers() | Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.
boolean | Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
boolean | Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
boolean | Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.
boolean [storesLowerCaseIdentifiers](https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#storesLowerCaseIdentifiers-...)
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.
boolean [storesLowerCaseQuotedIdentifiers](https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#storesLowerCaseQuotedIdenti...)
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
boolean [storesMixedCaseIdentifiers](https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#storesMixedCaseIdentifiers-...)
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
boolean [storesMixedCaseQuotedIdentifiers](https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#storesMixedCaseQuotedIdenti...)
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.
AFAICT, we are correct in saying storesLowerCaseIdentifiers = true as that is what PostgreSQL does.
Seems the problem may be with spring
view thread (6+ messages) latest in thread
reply
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: github://pgjdbc/pgjdbc
Cc: [email protected], [email protected]
Subject: Re: [pgjdbc/pgjdbc] issue #3722: spring jdbc causes problems with uppercase db names since 42.7.5
In-Reply-To: <<[email protected]>>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox