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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
