diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2010-08-26 19:58:50 +0000 | 
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2010-08-26 19:58:50 +0000 | 
| commit | 4ad4b95be26f6677d80cd744036b5e73c89406c7 (patch) | |
| tree | 7a2b213068b572cce50934ae125afea31521fe1b | |
| parent | 2b9a93a21ad7d139df56441b049bc633025107c7 (diff) | |
Update time zone data files to tzdata release 2010l: DST law changes in
Egypt and Palestine.  Added new names for two Micronesian timezones:
Pacific/Chuuk is now preferred over Pacific/Truk (and the preferred
abbreviation is CHUT not TRUT) and Pacific/Pohnpei is preferred over
Pacific/Ponape.  Historical corrections for Finland.
| -rw-r--r-- | src/timezone/data/africa | 19 | ||||
| -rw-r--r-- | src/timezone/data/asia | 15 | ||||
| -rw-r--r-- | src/timezone/data/australasia | 10 | ||||
| -rw-r--r-- | src/timezone/data/backward | 6 | ||||
| -rw-r--r-- | src/timezone/data/europe | 37 | ||||
| -rw-r--r-- | src/timezone/data/leapseconds | 12 | ||||
| -rw-r--r-- | src/timezone/data/northamerica | 81 | ||||
| -rw-r--r-- | src/timezone/data/zone.tab | 6 | ||||
| -rw-r--r-- | src/timezone/tznames/Default | 6 | ||||
| -rw-r--r-- | src/timezone/tznames/Pacific.txt | 7 | 
10 files changed, 168 insertions, 31 deletions
diff --git a/src/timezone/data/africa b/src/timezone/data/africa index 8cae7a682b0..481bc264bcb 100644 --- a/src/timezone/data/africa +++ b/src/timezone/data/africa @@ -1,5 +1,5 @@  # <pre> -# @(#)africa	8.26 +# @(#)africa	8.28  # This file is in the public domain, so clarified as of  # 2009-05-17 by Arthur David Olson. @@ -294,8 +294,25 @@ Rule	Egypt	2007	only	-	Sep	Thu>=1	23:00s	0	-  # and can be found by searching for "winter" in their search engine  # (at least today). +# From Alexander Krivenyshev (2010-07-20): +# According to News from Egypt -  Al-Masry Al-Youm Egypt's cabinet has +# decided that Daylight Saving Time will not be used in Egypt during +# Ramadan. +# +# Arabic translation: +# "Clocks to go back during Ramadan--and then forward again" +# <a href="http://www.almasryalyoum.com/en/news/clocks-go-back-during-ramadan-and-then-forward-again"> +# http://www.almasryalyoum.com/en/news/clocks-go-back-during-ramadan-and-then-forward-again +# </a> +# or +# <a href="http://www.worldtimezone.com/dst_news/dst_news_egypt02.html"> +# http://www.worldtimezone.com/dst_news/dst_news_egypt02.html +# </a> +  Rule	Egypt	2008	only	-	Aug	lastThu	23:00s	0	-  Rule	Egypt	2009	only	-	Aug	20	23:00s	0	- +Rule	Egypt	2010	only	-	Aug	11	0:00	0	- +Rule	Egypt	2010	only	-	Sep	10	0:00	1:00	S  Rule	Egypt	2010	max	-	Sep	lastThu	23:00s	0	-  # Zone	NAME		GMTOFF	RULES	FORMAT	[UNTIL] diff --git a/src/timezone/data/asia b/src/timezone/data/asia index 78ff2ffedcf..09158b669d3 100644 --- a/src/timezone/data/asia +++ b/src/timezone/data/asia @@ -1,4 +1,4 @@ -# @(#)asia	8.60 +# @(#)asia	8.61  # This file is in the public domain, so clarified as of  # 2009-05-17 by Arthur David Olson. @@ -2178,6 +2178,18 @@ Zone	Asia/Karachi	4:28:12 -	LMT	1907  # "At 12:01am Friday, clocks in Israel and the West Bank will change to  # 1:01am, while Gaza clocks will change at 12:01am Saturday morning." +# From Steffen Thorsen (2010-08-11): +# According to several sources, including +# <a href="http://www.maannews.net/eng/ViewDetails.aspx?ID=306795"> +# http://www.maannews.net/eng/ViewDetails.aspx?ID=306795 +# </a> +# the clocks were set back one hour at 2010-08-11 00:00:00 local time in  +# Gaza and the West Bank. +# Some more background info: +# <a href="http://www.timeanddate.com/news/time/westbank-gaza-end-dst-2010.html"> +# http://www.timeanddate.com/news/time/westbank-gaza-end-dst-2010.html +# </a> +  # The rules for Egypt are stolen from the `africa' file.  # Rule	NAME	FROM	TO	TYPE	IN	ON	AT	SAVE	LETTER/S  Rule EgyptAsia	1957	only	-	May	10	0:00	1:00	S @@ -2198,6 +2210,7 @@ Rule Palestine	2008	only	-	Aug	lastFri	2:00	0	-  Rule Palestine	2009	only	-	Mar	lastFri	0:00	1:00	S  Rule Palestine	2010	max	-	Mar	lastSat	0:01	1:00	S  Rule Palestine	2009	max	-	Sep	Fri>=1	2:00	0	- +Rule Palestine	2010	only	-	Aug	11	0:00	0	-  # Zone	NAME		GMTOFF	RULES	FORMAT	[UNTIL]  Zone	Asia/Gaza	2:17:52	-	LMT	1900 Oct diff --git a/src/timezone/data/australasia b/src/timezone/data/australasia index 9884b6750a7..36a81b0fba2 100644 --- a/src/timezone/data/australasia +++ b/src/timezone/data/australasia @@ -1,5 +1,5 @@  # <pre> -# @(#)australasia	8.17 +# @(#)australasia	8.18  # This file is in the public domain, so clarified as of  # 2009-05-17 by Arthur David Olson. @@ -346,10 +346,10 @@ Zone Pacific/Kwajalein	11:09:20 -	LMT	1901  # Micronesia  # Zone	NAME		GMTOFF	RULES	FORMAT	[UNTIL] -Zone Pacific/Truk	10:07:08 -	LMT	1901 -			10:00	-	TRUT			# Truk Time -Zone Pacific/Ponape	10:32:52 -	LMT	1901		# Kolonia -			11:00	-	PONT			# Ponape Time +Zone Pacific/Chuuk	10:07:08 -	LMT	1901 +			10:00	-	CHUT			# Chuuk Time +Zone Pacific/Pohnpei	10:32:52 -	LMT	1901		# Kolonia +			11:00	-	PONT			# Pohnpei Time  Zone Pacific/Kosrae	10:51:56 -	LMT	1901  			11:00	-	KOST	1969 Oct	# Kosrae Time  			12:00	-	KOST	1999 diff --git a/src/timezone/data/backward b/src/timezone/data/backward index c896968c9ab..f1f95a89415 100644 --- a/src/timezone/data/backward +++ b/src/timezone/data/backward @@ -1,5 +1,5 @@  # <pre> -# @(#)backward	8.8 +# @(#)backward	8.9  # This file is in the public domain, so clarified as of  # 2009-05-17 by Arthur David Olson. @@ -90,7 +90,9 @@ Link	Pacific/Chatham		NZ-CHAT  Link	America/Denver		Navajo  Link	Asia/Shanghai		PRC  Link	Pacific/Pago_Pago	Pacific/Samoa -Link	Pacific/Truk		Pacific/Yap +Link	Pacific/Chuuk		Pacific/Yap +Link	Pacific/Chuuk		Pacific/Truk +Link	Pacific/Pohnpei		Pacific/Ponape  Link	Europe/Warsaw		Poland  Link	Europe/Lisbon		Portugal  Link	Asia/Taipei		ROC diff --git a/src/timezone/data/europe b/src/timezone/data/europe index aca3a0bd3ae..8ca6d8f7152 100644 --- a/src/timezone/data/europe +++ b/src/timezone/data/europe @@ -1,5 +1,5 @@  # <pre> -# @(#)europe	8.26 +# @(#)europe	8.27  # This file is in the public domain, so clarified as of  # 2009-05-17 by Arthur David Olson. @@ -1013,22 +1013,47 @@ Zone	Europe/Tallinn	1:39:00	-	LMT	1880  			2:00	EU	EE%sT  # Finland -# +  # From Hannu Strang (1994-09-25 06:03:37 UTC):  # Well, here in Helsinki we're just changing from summer time to regular one,  # and it's supposed to change at 4am... + +# From Janne Snabb (2010-0715):  # -# From Paul Eggert (2006-03-22): -# Shanks & Pottenger say Finland has switched at 02:00 standard time -# since 1981.  Go with Strang instead. +# I noticed that the Finland data is not accurate for years 1981 and 1982. +# During these two first trial years the DST adjustment was made one hour +# earlier than in forthcoming years. Starting 1983 the adjustment was made +# according to the central European standards. +# +# This is documented in Heikki Oja: Aikakirja 2007, published by The Almanac +# Office of University of Helsinki, ISBN 952-10-3221-9, available online (in +# Finnish) at +# +# <a href="http://almanakka.helsinki.fi/aikakirja/Aikakirja2007kokonaan.pdf"> +# http://almanakka.helsinki.fi/aikakirja/Aikakirja2007kokonaan.pdf +# </a> +# +# Page 105 (56 in PDF version) has a handy table of all past daylight savings +# transitions. It is easy enough to interpret without Finnish skills. +# +# This is also confirmed by Finnish Broadcasting Company's archive at:  # +# <a href="http://www.yle.fi/elavaarkisto/?s=s&g=1&ag=5&t=&a=3401"> +# http://www.yle.fi/elavaarkisto/?s=s&g=1&ag=5&t=&a=3401 +# </a> +# +# The news clip from 1981 says that "the time between 2 and 3 o'clock does not +# exist tonight." +  # Rule	NAME	FROM	TO	TYPE	IN	ON	AT	SAVE	LETTER/S  Rule	Finland	1942	only	-	Apr	3	0:00	1:00	S  Rule	Finland	1942	only	-	Oct	3	0:00	0	- +Rule	Finland	1981	1982	-	Mar	lastSun	2:00	1:00	S +Rule	Finland	1981	1982	-	Sep	lastSun	3:00	0	-  # Zone	NAME		GMTOFF	RULES	FORMAT	[UNTIL]  Zone	Europe/Helsinki	1:39:52 -	LMT	1878 May 31  			1:39:52	-	HMT	1921 May    # Helsinki Mean Time -			2:00	Finland	EE%sT	1981 Mar 29 2:00 +			2:00	Finland	EE%sT	1983  			2:00	EU	EE%sT  # Aaland Is diff --git a/src/timezone/data/leapseconds b/src/timezone/data/leapseconds index a3c95efb1c8..d70185c6904 100644 --- a/src/timezone/data/leapseconds +++ b/src/timezone/data/leapseconds @@ -1,5 +1,5 @@  # <pre> -# @(#)leapseconds	8.9 +# @(#)leapseconds	8.10  # This file is in the public domain, so clarified as of  # 2009-05-17 by Arthur David Olson. @@ -60,9 +60,9 @@ Leap	2008	Dec	31	23:59:60	+	S  # FAX       : 33 (0) 1 40 51 22 91  # Internet  : services.iers@obspm.fr  # -# Paris, 4 July 2009 +# Paris, 14 July 2010  # -# Bulletin C 38 +# Bulletin C 40  #  # To authorities responsible  # for the measurement and @@ -70,9 +70,9 @@ Leap	2008	Dec	31	23:59:60	+	S  #  # INFORMATION ON UTC - TAI  # -# NO positive leap second will be introduced at the end of December 2009. +# NO positive leap second will be introduced at the end of December 2010.  # The difference between Coordinated Universal Time UTC and the -# International Atomic Time TAI is :		 +# International Atomic Time TAI is :  #  # from 2009 January 1, 0h UTC, until further notice : UTC-TAI = -34 s  # @@ -82,6 +82,6 @@ Leap	2008	Dec	31	23:59:60	+	S  # will be no time step at the next possible date.  #  # Daniel GAMBIS -# Director			 +# Director  # Earth Orientation Center of IERS  # Observatoire de Paris, France diff --git a/src/timezone/data/northamerica b/src/timezone/data/northamerica index ae9ca5746fc..7dfd064f23f 100644 --- a/src/timezone/data/northamerica +++ b/src/timezone/data/northamerica @@ -1,5 +1,5 @@  # <pre> -# @(#)northamerica	8.31 +# @(#)northamerica	8.34  # This file is in the public domain, so clarified as of  # 2009-05-17 by Arthur David Olson. @@ -1324,6 +1324,83 @@ Zone America/Montreal	-4:54:16 -	LMT	1884  # entry since our cutoff date of 1970, so we can move  # America/Coral_Harbour to the 'backward' file. +# From Mark Brader (2010-03-06): +# +# Currently the database has: +# +# # Ontario +# +# # From Paul Eggert (2006-07-09): +# # Shanks & Pottenger write that since 1970 most of Ontario has been like +# # Toronto. +# # Thunder Bay skipped DST in 1973. +# # Many smaller locales did not observe peacetime DST until 1974; +# # Nipigon (EST) and Rainy River (CST) are the largest that we know of. +# +# In the (Toronto) Globe and Mail for Saturday, 1955-09-24, in the bottom +# right corner of page 1, it says that Toronto will return to standard +# time at 2 am Sunday morning (which agrees with the database), and that: +# +#     The one-hour setback will go into effect throughout most of Ontario, +#     except in areas like Windsor which remains on standard time all year. +# +# Windsor is, of course, a lot larger than Nipigon. +# +# I only came across this incidentally.  I don't know if Windsor began +# observing DST when Detroit did, or in 1974, or on some other date. +# +# By the way, the article continues by noting that: +# +#     Some cities in the United States have pushed the deadline back +#     three weeks and will change over from daylight saving in October. + +# From Arthur David Olson (2010-07-17): +# +# "Standard Time and Time Zones in Canada" appeared in +# The Journal of The Royal Astronomical Society of Canada, +# volume 26, number 2 (February 1932) and, as of 2010-07-17, +# was available at +# <a href="http://adsabs.harvard.edu/full/1932JRASC..26...49S"> +# http://adsabs.harvard.edu/full/1932JRASC..26...49S +# </a> +# +# It includes the text below (starting on page 57): +# +#   A list of the places in Canada using daylight saving time would +# require yearly revision. From information kindly furnished by +# the provincial governments and by the postmasters in many cities +# and towns, it is found that the following places used daylight sav- +# ing in 1930. The information for the province of Quebec is definite, +# for the other provinces only approximate: +# +# 	Province	Daylight saving time used +# Prince Edward Island	Not used. +# Nova Scotia		In Halifax only. +# New Brunswick		In St. John only. +# Quebec		In the following places: +# 			Montreal	Lachine +# 			Quebec		Mont-Royal +# 			Levis		Iberville +# 			St. Lambert	Cap de la Madeleine +# 			Verdun		Loretteville +# 			Westmount	Richmond +# 			Outremont	St. Jerome +# 			Longueuil	Greenfield Park +# 			Arvida		Waterloo +# 			Chambly-Canton	Beaulieu +# 			Melbourne	La Tuque +# 			St. Theophile	Buckingham +# Ontario		Used generally in the cities and towns along +# 			the southerly part of the province. Not +# 			used in the northwesterlhy part. +# Manitoba		Not used. +# Saskatchewan		In Regina only. +# Alberta		Not used. +# British Columbia	Not used. +# +#   With some exceptions, the use of daylight saving may be said to be limited +# to those cities and towns lying between Quebec city and Windsor, Ont. +  # Rule	NAME	FROM	TO	TYPE	IN	ON	AT	SAVE	LETTER/S  Rule	Toronto	1919	only	-	Mar	30	23:30	1:00	D  Rule	Toronto	1919	only	-	Oct	26	0:00	0	S @@ -2147,7 +2224,7 @@ Zone America/Bahia_Banderas	-7:01:00 -	LMT	1921 Dec 31 23:59:00  			-6:00	-	CST	1942 Apr 24  			-7:00	-	MST	1949 Jan 14  			-8:00	-	PST	1970 -			-7:00	Mexico	M%sT	2010 Apr 4 +			-7:00	Mexico	M%sT	2010 Apr 4 2:00  			-6:00	Mexico	C%sT  # Baja California (near US border) diff --git a/src/timezone/data/zone.tab b/src/timezone/data/zone.tab index 2e060862e74..1dc2addeafb 100644 --- a/src/timezone/data/zone.tab +++ b/src/timezone/data/zone.tab @@ -1,5 +1,5 @@  # <pre> -# @(#)zone.tab	8.36 +# @(#)zone.tab	8.37  # This file is in the public domain, so clarified as of  # 2009-05-17 by Arthur David Olson.  # @@ -177,8 +177,8 @@ ET	+0902+03842	Africa/Addis_Ababa  FI	+6010+02458	Europe/Helsinki  FJ	-1808+17825	Pacific/Fiji  FK	-5142-05751	Atlantic/Stanley -FM	+0725+15147	Pacific/Truk	Truk (Chuuk) and Yap -FM	+0658+15813	Pacific/Ponape	Ponape (Pohnpei) +FM	+0725+15147	Pacific/Chuuk	Chuuk (Truk) and Yap +FM	+0658+15813	Pacific/Pohnpei	Pohnpei (Ponape)  FM	+0519+16259	Pacific/Kosrae	Kosrae  FO	+6201-00646	Atlantic/Faroe  FR	+4852+00220	Europe/Paris diff --git a/src/timezone/tznames/Default b/src/timezone/tznames/Default index c5df6afe7cd..97d808fe7a0 100644 --- a/src/timezone/tznames/Default +++ b/src/timezone/tznames/Default @@ -4,7 +4,7 @@  # timezone_abbreviations to 'Default'.  See the `Date/Time Support'  # appendix in the PostgreSQL documentation for more information.  # -# $PostgreSQL: pgsql/src/timezone/tznames/Default,v 1.9 2010/05/11 22:36:52 tgl Exp $ +# $PostgreSQL: pgsql/src/timezone/tznames/Default,v 1.9.2.1 2010/08/26 19:58:50 tgl Exp $  #################### AFRICA #################### @@ -661,6 +661,8 @@ CHADT   49500 D  # Chatham Daylight Time (New Zealand)                   #     (Pacific/Chatham)  CHAST   45900    # Chatham Standard Time (New Zealand)                   #     (Pacific/Chatham) +CHUT    36000    # Chuuk Time +                 #     (Pacific/Chuuk)  CKT     43200    # Cook Islands Time (not in zic)  EASST  -18000 D  # Easter Island Summer Time (Chile)                   #     (Pacific/Easter) @@ -712,7 +714,7 @@ TAHT   -36000    # Tahiti Time (zic says "TAHT", other sources "THAT")  TKT    -36000    # Tokelau Time                   #     (Pacific/Fakaofo)  TOT     46800    # Tonga Time (not in zic) -TRUT    36000    # Truk Time (zic says "TRUT", other souces say "TRUK") +TRUT    36000    # Truk Time (zic used to say "TRUT", other sources say "TRUK")                   #     (Pacific/Truk)  TVT     43200    # Tuvalu Time                   #     (Pacific/Funafuti) diff --git a/src/timezone/tznames/Pacific.txt b/src/timezone/tznames/Pacific.txt index dad2d483d11..b5f759bedef 100644 --- a/src/timezone/tznames/Pacific.txt +++ b/src/timezone/tznames/Pacific.txt @@ -4,7 +4,7 @@  #   a template for timezones you could need.  See the `Date/Time Support'  #   appendix in the PostgreSQL documentation for more information.  # -# $PostgreSQL: pgsql/src/timezone/tznames/Pacific.txt,v 1.2 2006/07/25 13:49:21 tgl Exp $ +# $PostgreSQL: pgsql/src/timezone/tznames/Pacific.txt,v 1.2.18.1 2010/08/26 19:58:50 tgl Exp $  #  CHADT   49500 D  # Chatham Daylight Time (New Zealand) @@ -14,6 +14,8 @@ CHAST   45900    # Chatham Standard Time (New Zealand)  ChST    36000    # Chamorro Standard Time (lower case "h" is as in zic)                   #     (Pacific/Guam)                   #     (Pacific/Saipan) +CHUT    36000    # Chuuk Time +                 #     (Pacific/Chuuk)  CKT     43200    # Cook Islands Time (not in zic)  EASST  -18000 D  # Easter Island Summer Time (Chile)                   #     (Pacific/Easter) @@ -84,7 +86,7 @@ TAHT   -36000    # Tahiti Time (zic says "TAHT", other sources "THAT")  TKT    -36000    # Tokelau Time                   #     (Pacific/Fakaofo)  TOT     46800    # Tonga Time (not in zic) -TRUT    36000    # Truk Time (zic says "TRUT", other souces say "TRUK") +TRUT    36000    # Truk Time (zic used to say "TRUT", other sources say "TRUK")                   #     (Pacific/Truk)  TVT     43200    # Tuvalu Time                   #     (Pacific/Funafuti) @@ -99,4 +101,3 @@ WFT     43200    # Wallis and Futuna Time  WST    -39600    # West Samoa Time                   #     (Pacific/Apia)  YAPT    36000    # Yap Time (Micronesia) (not in zic) -  | 
