Message-ID: <gh-pgjdbc-pgjdbc-3685-c3000224361@github.com>
From: "desruisseaux (@desruisseaux)" <noreply+desruisseaux@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Tue, 24 Jun 2025 12:31:16 +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: 3000224361
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3685
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3685#issuecomment-3000224361
Content-Type: text/plain; charset=utf-8

Yes, the same query work in PGAdmin. It also works in NetBeans and IntelliJ, which I presume use `DriverManager`. The problem occurs only with `PGSimpleDataSource`. In the `/var/lib/pgsql/data/log/postgresql-Tue.log` file, I find nothing more than what the exception is saying:

```
2025-06-24 14:25:34.136 CEST [51615] LOG:  le système de bases de données est prêt pour accepter les connexions
2025-06-24 14:27:03.178 CEST [51974] ERREUR:  column "features"."SpatialData"."geometry" must be a geometry or geography
2025-06-24 14:27:03.178 CEST [51974] INSTRUCTION :  SELECT public.ST_EstimatedExtent('features', 'SpatialData', 'geometry')
```