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

From Diffor
Subject Re: BUG #5466: Asia/Novosibirsk timezone problem
Date
Msg-id AANLkTilpbzpwpvCUUAVFQMC5PSD0N3SJRSoQ7ne6F0zl@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5466: Asia/Novosibirsk timezone problem  (Diffor <diffor@gmail.com>)
List pgsql-bugs
2010/5/20 Diffor <diffor@gmail.com>

> December 2009 cumulative time zone update for Microsoft Windows operating
> systems:
> http://support.microsoft.com/?kbid=3D976098
>
> pgtz.c is outdated:
> >N. Central Asia Standard Time:
> >Removes =93Almaty=94 from the =93(GMT+06:00) Almaty, Novosibirsk=94 time=
 zone.
>

I contact people from Astana. Windows users from Almaty use "(GMT+06:00)
Astana" time zone (Central Asia Standard Time). This city have no DST and in
same country (KZ).

IMHO need patch src/timezone/pgtz.c :
892c892
<               "Asia/Almaty"
---
>               "Asia/Novosibirsk"

pgsql-bugs by date:

Previous
From: "KOIZUMI Satoru"
Date:
Subject: BUG #5467: wrong classification at index
Next
From: Krzysztof Nienartowicz
Date:
Subject: Query causing explosion of temp space with join involving partitioning