Re: Java's set of timezone names - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Java's set of timezone names
Date
Msg-id 42E5E155.20700@opencloud.com
Whole thread Raw
In response to Re: Java's set of timezone names  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Tom Lane wrote:
> Vadim Nasardinov <vadimn@redhat.com> writes:
>
>>If 8.0 comes with its own copy of a recent zic database, then, in
>>theory, it should be able to handle any timezone known to Java.  (The
>>opposite is not necessarily true, as Java's timezone info seems to be
>>missing a lot of recent changes.)  Does that sound like a correct
>>statement to you or did I forget some important qualifiers?
>
>
> Yeah, it seems that we are just open to version skew issues between
> different copies of the zic database ... which changes enough that
> that's a nontrivial risk, but I fear we are unlikely to do better.

I noticed in passing that Java and postgres have different ideas about
what (for example) "GMT+10" as a timezone name means. Java considers
that to be east of GMT, postgres thinks it is west.

-O

pgsql-jdbc by date:

Previous
From: "Rashmi"
Date:
Subject: UNSUBSCRIBE
Next
From: Marc Herbert
Date:
Subject: Re: getObject() returns integer instead of LargeObject