From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: tzdata2017a breaks timestamptz regression test
Date: Fri, 10 Mar 2017 10:53:29 -0300
Message-ID: <20170310135329.rvcrcsamoj5jlu4j@alvherre.pgsql> (raw)
In-Reply-To: <6749.1489087470@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Tom Lane wrote:
> For the cases involving the America/Santiago zone, I'm a bit inclined
> to just switch that to America/New_York, which seems much less likely
> to get fooled with by IANA. But I'm wondering if Alvaro had a specific
> reason for using the Santiago zone in those test cases.
No, I just used the Santiago zone because it was local. But I agree
it's a bad one to use, because in the last decade politicians have been
playing with it excessively, so +1 for changing to something else.
> What I propose we do about that is replace the America/Caracas test cases
> with Europe/Moscow tests, moving the dates as needed to match DST
> transitions from when Moscow was observing DST (pre 2011). The comments
> in the IANA files indicate that they believe the MSK/MSD abbreviations
> have or had real-world usage, so they probably won't replace them with
> numeric offsets. We can hope, anyway.
Sounds reasonable to me.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: alvherre@2ndquadrant.com, tgl@sss.pgh.pa.us
Subject: Re: tzdata2017a breaks timestamptz regression test
In-Reply-To: <20170310135329.rvcrcsamoj5jlu4j@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox