Message-ID: <gh-pgjdbc-pgjdbc-3505-c2651694974@github.com>
From: "MalloD12 (@MalloD12)" <noreply+MalloD12@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Tue, 11 Feb 2025 18:42:28 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3505: Metadata queries are much slower after update to 24.7.5
In-Reply-To: <gh-pgjdbc-pgjdbc-3505@github.com>
References: <gh-pgjdbc-pgjdbc-3505@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: MalloD12
X-GitHub-Comment-Id: 2651694974
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3505
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3505#issuecomment-2651694974
Content-Type: text/plain; charset=utf-8

From a Liquibase point of view, this is affecting us because we lowercase the catalog name. This is causing problems like the one one of our users is reporting [here](https://github.com/liquibase/liquibase/issues/6666):

> Upgrading the PostgreSQL JDBC driver from 42.7.4 to 42.7.5 causes Liquibase to fail during (a second) server startup, as it does not recognize the existing databasechangelog table and attempts to create it again, resulting in an error: relation "databasechangelog" already exists
The error prevents server startup, making the application unusable.

Thanks,
Daniel.