From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Dmitry Funk <diffor(at)gmail(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #5466: Asia/Novosibirsk timezone problem |
Date: | 2010-05-19 19:12:34 |
Message-ID: | 1274296098-sup-8306@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Excerpts from Magnus Hagander's message of mié may 19 15:03:25 -0400 2010:
> On Wed, May 19, 2010 at 3:00 PM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> > Excerpts from Dmitry Funk's message of mié may 19 13:44:35 -0400 2010:
> >> Current system timezone: Asia/Novosibisk
> >>
> >> PostgreSQL on query "show timezone" show answer "Asia/Almaty"
> >>
> >> Asia/Novosibisk has daylight saving time
> >> Asia/Almaty NOT has daylight saving time
> >> and result of now() is wrong
> >>
> >> Workaround: "timezone = 'Asia/Novosibirsk'" in postgresql.conf
> >>
> >> Affected only Windows, not Linux.
> >
> > We have this in pgtz.c:
> >
> > {
> > "N. Central Asia Standard Time", "N. Central Asia Daylight Time",
> > "Asia/Almaty"
> > }, /* (GMT+06:00) Almaty, Novosibirsk */
> >
> > Which is probably wrong.
>
> Why? :-)
>
> Windows makes no difference between Almaty and Novosibirsk in it's
> listing. If we pick the Novosibirsk one by default, that will just
> break Almaty. There's no real easy way for us to find the difference
> between those, since we're just matching on those two strings.
Well, ISTM it does make a difference, which is that there *is* DST info
in the N. Central Asia Standard Time zone, no? According the Dmitry,
Almaty doesn't have DST, so it's wrong to report that zone.
I happened to notice this page:
http://www.chronos-st.org/Windows-to-Olson.html
which also maps "N. Central Asia" to Novosibirsk.
--
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2010-05-19 19:17:50 | Re: BUG #5466: Asia/Novosibirsk timezone problem |
Previous Message | Magnus Hagander | 2010-05-19 19:03:25 | Re: BUG #5466: Asia/Novosibirsk timezone problem |