Message-ID: <gh-pgjdbc-pgjdbc-3731-c3127252614@github.com>
From: "monclaf (@monclaf)" <noreply+monclaf@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 28 Jul 2025 13:29:15 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3731: Entity Manager Creation issue with jdbc driver > 42.7.4
In-Reply-To: <gh-pgjdbc-pgjdbc-3731@github.com>
References: <gh-pgjdbc-pgjdbc-3731@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: monclaf
X-GitHub-Comment-Id: 3127252614
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3731
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3731#issuecomment-3127252614
Content-Type: text/plain; charset=utf-8

Hello @vlsi 
I finally succeeded in creating a reproducer :
[Z_JDBC_POSTGRESQL_DRIVER_ISSUE.zip](https://github.com/user-attachments/files/21470263/Z_JDBC_POSTGRESQL_DRIVER_ISSUE.zip)
I understand the root cause, but I don't know if it's directly or indirectly caused by the versions: postgresql-42.7.5, 6 and 7.
The cause of the problem is that I'm using uppercase letters to name the database and the jdbc driver is affected when it searches for database tables and, as a result, JPA tries to create tables that already exist when it's configured to automatically build the database schema (persistence.xml). Can you confirm ?
The issue is simple to reproduce, 
- create a database with lowercase run java program to build the schema
- run again the program to create the entity manager
- rename the database using uppercase
- run again the program that will reproduce the issue and generate exception