Re: BUG #17911: Database or JDBC Driver Provides Incorrect Type

Please report this issue here:

    pgsql-jdbc@postgresql.org

---------------------------------------------------------------------------

On Thu, Apr 27, 2023 at 02:59:30PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> 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].
> 


-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Embrace your flaws.  They make you human, rather than perfect,
  which you will never be.