Message-ID: <gh-pgjdbc-pgjdbc-3504-c2662189106@github.com>
From: "avinashyn (@avinashyn)" <noreply+avinashyn@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 17 Feb 2025 06:39:07 +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: 2662189106
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-2662189106
Content-Type: text/plain; charset=utf-8

Ok So I mentioned earlier that it was OK assuming that getSchemas() work based on the catalog passed in input which is not the case. 

Let me explain my use-case.

In our UI - we show catalog and schema.
Based on the catalog selected, it's corresponding schema's will be shown.

Until 42.6 version, it was working perfectly as only the catalog passed in JDBC url was appearing and it's corresponding schemas's were shown but after we migrated to 42.7, it broke.

UI shows multiple catalogs but whichever option you select, it only fetches the schema which is passed in JDBC url which is wrong.

So In my opinion, either we need to fix getCatalogs() to get the proper catalog OR if we decide to get all catalogs from DB then their corresponding schemas should be fetched.
Either of the one needs to be fixed.

Please look into it and if you need PR for this please let me know the process so that I can create one.

Thanks.