Date: Fri, 10 Mar 2017 10:53:29 -0300
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
Message-ID: <20170310135329.rvcrcsamoj5jlu4j@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <6749.1489087470@sss.pgh.pa.us>
User-Agent: NeoMutt/20170206-195-7adf12 (1.7.2)
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

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