Re: Regarding timezone - Mailing list pgsql-general

From Dev Kumkar
Subject Re: Regarding timezone
Date
Msg-id CALSLE1NYXxkpUN7_t7H7C1pg6pm4cpjQHbva2msEtMv-U_2Lww@mail.gmail.com
Whole thread Raw
In response to Re: Regarding timezone  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Regarding timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Thu, Sep 18, 2014 at 12:01 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
The next set of minor releases, whenever those are (and no, there's
no schedule).

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.

It would break timezone reporting for historical Moscow timestamps, ie
they'd be printed as GMT-3 whether or not that was applicable at the time.
Don't know whether you care about that.

The column storing datetime is of type "timestamp" and timezone is not being stored. So should not be an issue for this particular use-case. For "timestamp with time zone" that was definitely an issue.
By the way won't that be issue anyways once the Moscow timezone is corrected in upgraded postgres version?

Regards...

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regarding timezone
Next
From: Adrian Klaver
Date:
Subject: Re: Regarding timezone