Skip site navigation (1) Skip section navigation (2)

Re: Timestamp weirdness

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <oliver(at)opencloud(dot)com>
Cc: <emergency(dot)shower(at)gmail(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>,<tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Timestamp weirdness
Date: 2005-07-26 17:51:03
Message-ID: s2e631c3.023@gwmta.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi Oliver,
 
You're saying that a timestampz read from the protocol stream on the
server side is always parsed into a TIMESTAMP WITH TIME ZONE.  When it
is assigned to a TIMESTAMP WITHOUT TIME ZONE, there is a cast.  The cast
converts the moment into the local time string for that moment in the
time zone of the database server.  I get that.
 
My question (not well stated, I'm sure) was whether there is a way to
know, on the server, at the point of handling the timestampz from the
protocol stream, that it is going to be assigned to a TIMESTAMP WITHOUT
TIME ZONE and use literal assignment rules (i.e., ignore the time zone
info) instead of the cast rules.  The next question was whether this
would break existing code.
 
It sounds like you're well along on another solution, so this becomes
acedemic.  I'm not sure how you're inferring a type with your approach,
but I guess I was thinking that it might be possible to infer
alternative types for a timestampz.
 
I'm new to PostgreSQL, so I appreciate the patience of those who are
intimately familiar with the code.  It's takes quite a while to scan
through source code and infer it all.  I'm hoping to gain a firm enough
understanding to contribute to the code without too many missteps.
 
-Kevin
 
 
>>> Oliver Jowett <oliver(at)opencloud(dot)com> 07/26/05 9:20 AM >>>
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


Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2005-07-26 18:05:25
Subject: Re: Timestamp weirdness
Previous:From: Kris JurkaDate: 2005-07-26 16:54:33
Subject: Re: SQLException and error code

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group