Message-ID: <gh-pgjdbc-pgjdbc-3504-c2740444765@github.com>
From: "avinashyn (@avinashyn)" <noreply+avinashyn@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Thu, 20 Mar 2025 13:22:34 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3504: Wrong schemas fetched for a given catalog as input
In-Reply-To: <gh-pgjdbc-pgjdbc-3504@github.com>
References: <gh-pgjdbc-pgjdbc-3504@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: avinashyn
X-GitHub-Comment-Id: 2740444765
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3504
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3504#issuecomment-2740444765
Content-Type: text/plain; charset=utf-8

Expectation here is w.r.t catalogs. 
Putting down your example

 jdbc:postgresql://localhost:5432/**foo**
Here getCatalogs() returns "foo" alone with 42.6.0 where as with 42.7 it returns

- catalog:contrib_regression
- catalog:foo
- catalog:postgres
- catalog:template1
- catalog:test

Expectation here is that it returns only "foo" even with 42.7 driver similar to 42.6 as that is the one passed in JDBC URL. 
So the way 42.6 driver version was working was correct IMO.