From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: postgresql@bergeon.org
Subject: BUG #17911: Database or JDBC Driver Provides Incorrect Type
Date: Thu, 27 Apr 2023 14:59:30 +0000
Message-ID: <17911-76b72ef0b040e9da@postgresql.org> (raw)
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].
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, postgresql@bergeon.org
Subject: Re: BUG #17911: Database or JDBC Driver Provides Incorrect Type
In-Reply-To: <17911-76b72ef0b040e9da@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox