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. -- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs