Re: Regarding timezone - Mailing list pgsql-general

From Dev Kumkar
Subject Re: Regarding timezone
Date
Msg-id CALSLE1P+Wof9ek7BjOkmLiLFGZ-jqJY7Mv8eBBowz2Sj+9ac=Q@mail.gmail.com
Whole thread Raw
In response to Re: Regarding timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Regarding timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Thu, Sep 18, 2014 at 1:22 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 09/17/2014 12:26 PM, Dev Kumkar wrote:
I hope the binaries archive containing ""pgsql/share/postgresql/
timezone/Europe/Moscow" uploaded at
http://www.enterprisedb.com/products-services-training/pgbindownload
will also get corrected.

They will.

Thanks, on 25 October 2014 the timezone will change permanently. Currently binaries are at 9.3.5.1 level, will keep an watch on the update.

No, because a timezone(versus an offset) definition includes a historical record of the changes in the timezone. For all the gory details see:

http://en.wikipedia.org/wiki/Tz_database

Great info! So the historical Moscow timestamps will still reflect GMT+4 based on the datetime.
Sure, awaiting fix and will cross-check the behavior.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Regarding timezone
Next
From: Dev Kumkar
Date:
Subject: Re: [SQL] pg_multixact issues