Bug reference: 17911 Logged by: Stephen Bergeon Email address: postgresql@bergeon.org PostgreSQL version: 15.2 Operating system: Windows 10 Description:
When the JDBC driver returns a ResultSet, both from obtaining table column info, as well as from an actual query, the DATA_TYPE returned is incorrect for Time-with-Time-Zone and Timestamp-With-Time-Zone columns. In both cases the returned value returned indicates that the non-time-zone value is returned.
This has been tested on multiple versions of PostgreSQL and its JDBC driver through the latest release [database version 15.2 and JDBC driver 42.6.0].