Message-ID: <gh-pgjdbc-pgjdbc-3505-c2651818471@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Tue, 11 Feb 2025 19:06:56 +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: davecramer
X-GitHub-Comment-Id: 2651818471
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-2651818471
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.

So if you lowercase the catalog the test should be true, no ?