Re: BUG #18495: invalid type mapping for timestamptz from call of: getMetaData and then geColumns on PgConnection.

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: jurajburian(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18495: invalid type mapping for timestamptz from call of: getMetaData and then geColumns on PgConnection.
Date: 2024-06-05 16:08:13
Message-ID: 50278655-71d7-4ca6-b85e-ca7434809c57@ewie.name
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2024-06-05 15:21 +0200, PG Bug reporting form wrote:
> I can see a non correct type mapping for timestamptz type. Code snippets
> used in descriptions are pure SQL or (Scala). We use latest JDBC driver
> (version 42.7.3).
> The bug is simple. Instead of Types.TIMESTAMP_WITH_TIMEZONE we obtain value
> of Types.TIMESTAMP in resultset from getMetadata wit consequential call of:
> geColumns.

It's a known issue: https://github.com/pgjdbc/pgjdbc/issues/1766

--
Erik

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2024-06-05 23:51:10 Re: BUG #17947: Combination of replslots pgstat issues causes error/assertion failure
Previous Message Alvaro Herrera 2024-06-05 15:39:44 Re: BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943