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

BUG #5466: Asia/Novosibirsk timezone problem

From: "Dmitry Funk" <diffor(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5466: Asia/Novosibirsk timezone problem
Date: 2010-05-19 17:44:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5466
Logged by:          Dmitry Funk
Email address:      diffor(at)gmail(dot)com
PostgreSQL version: 8.4.4
Operating system:   Windows 2003 R2
Description:        Asia/Novosibirsk timezone problem

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.

Sorry for my english...


pgsql-bugs by date

Next:From: Michael MeskesDate: 2010-05-19 18:40:56
Subject: Re: BUG #5464: ecpg on 64bit system converts "long long" to "long"
Previous:From: John R PierceDate: 2010-05-19 17:34:42
Subject: Re: BUG #5464: ecpg on 64bit system converts "long long" to "long"

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