Message-ID: <gh-pgjdbc-pgjdbc-3685-c3000593955@github.com>
From: "desruisseaux (@desruisseaux)" <noreply+desruisseaux@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Tue, 24 Jun 2025 13:52:34 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3685: Regression: a query does not work anymore on connection created by `PGSimpleDataSource` but still work with `DriverManager`
In-Reply-To: <gh-pgjdbc-pgjdbc-3685@github.com>
References: <gh-pgjdbc-pgjdbc-3685@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: desruisseaux
X-GitHub-Comment-Id: 3000593955
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2025-06-24T13:53:31Z
X-GitHub-Issue: 3685
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3685#issuecomment-3000593955
Content-Type: text/plain; charset=utf-8

Okay, exploring more the differences between the two URLs, the issue seems to be `?currentSchema=features`. Testing `DriverManager` with the URL built by `PGSimpleDataSource`, it works without `?currentSchema=features` but doesn't work if that fragment is present in the URL.

Testing on the command-line with `psql`, the `?currentSchema=features` fragment does not seem to be accepted at all. I do not see that parameter in the page [referenced from here](https://www.prisma.io/dataguide/postgresql/short-guides/connection-uris#specifying-additional-parameters). Is it still supported?

If not, should `PGSimpleDataSource.setCurrentSchema(String)` be deprecated?