Message-ID: <gh-pgjdbc-pgjdbc-3722-c3052518275@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Wed, 09 Jul 2025 12:39:18 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3722: spring jdbc causes problems with uppercase db names since 42.7.5
In-Reply-To: <gh-pgjdbc-pgjdbc-3722@github.com>
References: <gh-pgjdbc-pgjdbc-3722@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 3052518275
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3722
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3722#issuecomment-3052518275
Content-Type: text/plain; charset=utf-8

`DatabaseMetaData.storesLowerCaseIdentifiers` refers to normal queries. https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getTables-java.lang.String-java.lang.String-java.lang.String-java.lang.String:A- specifically states that columns are returned in UPPERCASE. I do see an argument where we would lowercase them, but the de facto standard seems to be to return them in UPPERCASE