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

Re: BUG #5466: Asia/Novosibirsk timezone problem

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
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:03:25
Message-ID: AANLkTik6jdOrZqPcThyQk1YTZzuBAubaPC2fwJTEBzQ6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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:
>
>> Description:        Asia/Novosibirsk timezone problem
>> Details:
>>
>> 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.

-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2010-05-19 19:12:34
Subject: Re: BUG #5466: Asia/Novosibirsk timezone problem
Previous:From: Alvaro HerreraDate: 2010-05-19 19:00:35
Subject: Re: BUG #5466: Asia/Novosibirsk timezone problem

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