Re: Timestamp weirdness - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Timestamp weirdness
Date
Msg-id 42E646BA.2030008@opencloud.com
Whole thread Raw
In response to Timestamp weirdness  ("emergency.shower@gmail.com" <emergency.shower@gmail.com>)
List pgsql-jdbc
Kevin Grittner wrote:

> I assume that the behavior of the server when receiving a timestampz
> within the protocol couldn't be changed to match the handling of a
> literal without breaking significant existing code.

(One more time!)

The parsing of timestamptz is just fine, it's the cast to timestamp that
breaks things.

If we get the server to infer a type for the parameter rather than
explicitly specifying it as timestamptz, then we can avoid that cast.
Then things don't break.

-O

pgsql-jdbc by date:

Previous
From: Peter.Zoche@materna.de
Date:
Subject: Re: SQLException and error code
Next
From: "Kevin Grittner"
Date:
Subject: Re: Timestamp weirdness