Re: BUG #5466: Asia/Novosibirsk timezone problem - Mailing list pgsql-bugs

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.
--