New Zealand - TZ change - Mailing list pgsql-patches

I would like to inform, that New Zealand changed DST rules and new
timezone files are available.  See
http://www.dia.govt.nz/diawebsite.nsf/wpg_URL/Services-Daylight-Saving-Daylight-saving-to-be-extended

Patch for head attached. I kept zic.c untouched, but I think it would be
nice to update it as well.

Are there any updated release scheduled 8.0-8.2?


        Zdenek

? tz.diff
Index: src/timezone/data/africa
===================================================================
RCS file: /projects/cvsroot/pgsql/src/timezone/data/africa,v
retrieving revision 1.5
diff -c -r1.5 africa
*** src/timezone/data/africa    19 Apr 2007 22:44:32 -0000    1.5
--- src/timezone/data/africa    25 Jun 2007 10:26:50 -0000
***************
*** 1,4 ****
! # @(#)africa    8.7
  # <pre>

  # This data is by no means authoritative; if you think you know better,
--- 1,4 ----
! # @(#)africa    8.8
  # <pre>

  # This data is by no means authoritative; if you think you know better,
***************
*** 416,421 ****
--- 416,435 ----
  # Namibia
  # The 1994-04-03 transition is from Shanks & Pottenger.
  # Shanks & Pottenger report no DST after 1998-04; go with IATA.
+
+ # From Petronella Sibeene (2007-03-30) in
+ # <http://allafrica.com/stories/200703300178.html>:
+ # While the entire country changes its time, Katima Mulilo and other
+ # settlements in Caprivi unofficially will not because the sun there
+ # rises and sets earlier compared to other regions.  Chief of
+ # Forecasting Riaan van Zyl explained that the far eastern parts of
+ # the country are close to 40 minutes earlier in sunrise than the rest
+ # of the country.
+ #
+ # From Paul Eggert (2007-03-31):
+ # Apparently the Caprivi Strip informally observes Botswana time, but
+ # we have no details.  In the meantime people there can use Africa/Gaborone.
+
  # RULE    NAME    FROM    TO    TYPE    IN    ON    AT    SAVE    LETTER/S
  Rule    Namibia    1994    max    -    Sep    Sun>=1    2:00    1:00    S
  Rule    Namibia    1995    max    -    Apr    Sun>=1    2:00    0    -
Index: src/timezone/data/australasia
===================================================================
RCS file: /projects/cvsroot/pgsql/src/timezone/data/australasia,v
retrieving revision 1.5
diff -c -r1.5 australasia
*** src/timezone/data/australasia    19 Apr 2007 22:44:32 -0000    1.5
--- src/timezone/data/australasia    25 Jun 2007 10:26:51 -0000
***************
*** 1,4 ****
! # @(#)australasia    8.6
  # <pre>

  # This file also includes Pacific islands.
--- 1,4 ----
! # @(#)australasia    8.7
  # <pre>

  # This file also includes Pacific islands.
***************
*** 348,357 ****
  Rule    Chatham    1976    1989    -    Mar    Sun>=1    2:45s    0    S
  Rule    NZ    1989    only    -    Oct    Sun>=8    2:00s    1:00    D
  Rule    Chatham    1989    only    -    Oct    Sun>=8    2:45s    1:00    D
! Rule    NZ    1990    max    -    Oct    Sun>=1    2:00s    1:00    D
! Rule    Chatham    1990    max    -    Oct    Sun>=1    2:45s    1:00    D
! Rule    NZ    1990    max    -    Mar    Sun>=15    2:00s    0    S
! Rule    Chatham    1990    max    -    Mar    Sun>=15    2:45s    0    S
  # Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
  Zone Pacific/Auckland    11:39:04 -    LMT    1868 Nov  2
              11:30    NZ    NZ%sT    1946 Jan  1
--- 348,361 ----
  Rule    Chatham    1976    1989    -    Mar    Sun>=1    2:45s    0    S
  Rule    NZ    1989    only    -    Oct    Sun>=8    2:00s    1:00    D
  Rule    Chatham    1989    only    -    Oct    Sun>=8    2:45s    1:00    D
! Rule    NZ    1990    2006    -    Oct    Sun>=1    2:00s    1:00    D
! Rule    Chatham    1990    2006    -    Oct    Sun>=1    2:45s    1:00    D
! Rule    NZ    1990    2007    -    Mar    Sun>=15    2:00s    0    S
! Rule    Chatham    1990    2007    -    Mar    Sun>=15    2:45s    0    S
! Rule    NZ    2007    max    -    Sep    lastSun    2:00s    1:00    D
! Rule    Chatham    2007    max    -    Sep    lastSun    2:45s    1:00    D
! Rule    NZ    2008    max    -    Apr    Sun>=1    2:00s    0    S
! Rule    Chatham    2008    max    -    Apr    Sun>=1    2:45s    0    S
  # Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
  Zone Pacific/Auckland    11:39:04 -    LMT    1868 Nov  2
              11:30    NZ    NZ%sT    1946 Jan  1
***************
*** 1146,1151 ****
--- 1150,1161 ----
  # transitions at 2:45 local standard time; this confirms that Chatham
  # is always exactly 45 minutes ahead of Auckland.

+ # From Colin Sharples (2007-04-30):
+ # DST will now start on the last Sunday in September, and end on the
+ # first Sunday in April.  The changes take effect this year, meaning
+ # that DST will begin on 2007-09-30 2008-04-06.
+ # http://www.dia.govt.nz/diawebsite.nsf/wpg_URL/Services-Daylight-Saving-Daylight-saving-to-be-extended
+
  ###############################################################################


Index: src/timezone/data/northamerica
===================================================================
RCS file: /projects/cvsroot/pgsql/src/timezone/data/northamerica,v
retrieving revision 1.7
diff -c -r1.7 northamerica
*** src/timezone/data/northamerica    19 Apr 2007 22:44:32 -0000    1.7
--- src/timezone/data/northamerica    25 Jun 2007 10:26:54 -0000
***************
*** 1,4 ****
! # @(#)northamerica    8.16
  # <pre>

  # also includes Central America and the Caribbean
--- 1,4 ----
! # @(#)northamerica    8.17
  # <pre>

  # also includes Central America and the Caribbean
***************
*** 2325,2330 ****
--- 2325,2333 ----
  #
  # The reason seems to be an energy crisis.

+ # From Stephen Colebourne (2007-02-22):
+ # Some IATA info: Haiti won't be having DST in 2007.
+

  # Rule    NAME    FROM    TO    TYPE    IN    ON    AT    SAVE    LETTER/S
  Rule    Haiti    1983    only    -    May    8    0:00    1:00    D
***************
*** 2334,2341 ****
  # Go with IATA.
  Rule    Haiti    1988    1997    -    Apr    Sun>=1    1:00s    1:00    D
  Rule    Haiti    1988    1997    -    Oct    lastSun    1:00s    0    S
! Rule    Haiti    2005    max    -    Apr    Sun>=1    0:00    1:00    D
! Rule    Haiti    2005    max    -    Oct    lastSun    0:00    0    S
  # Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
  Zone America/Port-au-Prince -4:49:20 -    LMT    1890
              -4:49    -    PPMT    1917 Jan 24 12:00 # P-a-P MT
--- 2337,2344 ----
  # Go with IATA.
  Rule    Haiti    1988    1997    -    Apr    Sun>=1    1:00s    1:00    D
  Rule    Haiti    1988    1997    -    Oct    lastSun    1:00s    0    S
! Rule    Haiti    2005    2006    -    Apr    Sun>=1    0:00    1:00    D
! Rule    Haiti    2005    2006    -    Oct    lastSun    0:00    0    S
  # Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
  Zone America/Port-au-Prince -4:49:20 -    LMT    1890
              -4:49    -    PPMT    1917 Jan 24 12:00 # P-a-P MT
***************
*** 2518,2530 ****
              -4:00    -    AST

  # Turks and Caicos
! # From Paul Eggert (2006-03-22):
  # Shanks & Pottenger say they use US DST rules, but IATA SSIM (1991/1998)
! # says they switch at midnight.  Go with IATA SSIM.
  # Rule    NAME    FROM    TO    TYPE    IN    ON    AT    SAVE    LETTER/S
! Rule    TC    1979    1986    -    Apr    lastSun    0:00    1:00    D
! Rule    TC    1979    max    -    Oct    lastSun    0:00    0    S
! Rule    TC    1987    max    -    Apr    Sun>=1    0:00    1:00    D
  # Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
  Zone America/Grand_Turk    -4:44:32 -    LMT    1890
              -5:07:12 -    KMT    1912 Feb    # Kingston Mean Time
--- 2521,2551 ----
              -4:00    -    AST

  # Turks and Caicos
! #
! # From Chris Dunn in
! # <http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=415007>
! # (2007-03-15): In the Turks & Caicos Islands (America/Grand_Turk) the
! # daylight saving dates for time changes have been adjusted to match
! # the recent U.S. change of dates.
! #
! # From Brian Inglis (2007-04-28):
! # http://www.turksandcaicos.tc/calendar/index.htm [2007-04-26]
! # there is an entry for Nov 4 "Daylight Savings Time Ends 2007" and three
! # rows before that there is an out of date entry for Oct:
! # "Eastern Standard Times Begins 2007
! # Clocks are set back one hour at 2:00 a.m. local Daylight Saving Time"
! # indicating that the normal ET rules are followed.
! #
! # From Paul Eggert (2006-05-01):
  # Shanks & Pottenger say they use US DST rules, but IATA SSIM (1991/1998)
! # says they switch at midnight.  Go with Shanks & Pottenger.
! #
  # Rule    NAME    FROM    TO    TYPE    IN    ON    AT    SAVE    LETTER/S
! Rule    TC    1979    1986    -    Apr    lastSun    2:00    1:00    D
! Rule    TC    1979    2006    -    Oct    lastSun    2:00    0    S
! Rule    TC    1987    2006    -    Apr    Sun>=1    2:00    1:00    D
! Rule    TC    2007    max    -    Mar    Sun>=8    2:00    1:00    D
! Rule    TC    2007    max    -    Nov    Sun>=1    2:00    0    S
  # Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
  Zone America/Grand_Turk    -4:44:32 -    LMT    1890
              -5:07:12 -    KMT    1912 Feb    # Kingston Mean Time