Re: Use of recent Russian TZ changes in regression tests - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Use of recent Russian TZ changes in regression tests
Date
Msg-id 24424.1416351230@sss.pgh.pa.us
Whole thread Raw
In response to Re: Use of recent Russian TZ changes in regression tests  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Use of recent Russian TZ changes in regression tests  (Christoph Berg <cb@df7cb.de>)
List pgsql-hackers
I wrote:
> Another thought that just occurred to me is that we need to test
> both advance and retreat of a zone's notion of standard time, but
> that doesn't mean that both cases have to be tested in the same
> zone.  The 2011 Russian advance is probably reasonable to depend
> on by now, but maybe we could find some other well-documented case
> where a zone's standard time offset decreased relative to UTC.

Ah, here we go:

# Venezuela
#
# From John Stainforth (2007-11-28):
# ... the change for Venezuela originally expected for 2007-12-31 has
# been brought forward to 2007-12-09.  The official announcement was
# published today in the "Gaceta Oficial de la República Bolivariana
# de Venezuela, número 38.819" (official document for all laws or
# resolution publication)
# http://www.globovision.com/news.php?nid=72208

# Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
Zone    America/Caracas    -4:27:44 -    LMT    1890        -4:27:40 -    CMT    1912 Feb 12 # Caracas Mean Time?
-4:30    -    VET    1965        # Venezuela Time        -4:00    -    VET    2007 Dec  9  3:00        -4:30    -
VET

That 2007 change has the right sign (becoming more negative relative
to UTC), and it seems pretty solidly documented so it's unlikely to
change on us in future.  Being in the other direction from Greenwich
shouldn't be an issue, maybe it's even better for coverage purposes.

Hence, proposal: leave the MSK 2011 cases as-is but replace the 2014
cases with comparable testing around the VET 2007 change.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Use of recent Russian TZ changes in regression tests
Next
From: Peter Geoghegan
Date:
Subject: Re: GIN pageinspect functions