Re: Use of recent Russian TZ changes in regression tests

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Use of recent Russian TZ changes in regression tests
Дата
Msg-id 24424.1416351230@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Use of recent Russian TZ changes in regression tests  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Use of recent Russian TZ changes in regression tests  (Christoph Berg <cb@df7cb.de>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Use of recent Russian TZ changes in regression tests
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: GIN pageinspect functions