| From: | Xavier Bugaud <xavier(dot)bugaud(at)gloptv(dot)com> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | Problem with Mauritius summer time (MUST) | 
| Date: | 2009-03-04 06:58:42 | 
| Message-ID: | 200903041158.42282.xavier.bugaud@gloptv.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hi,
Mauritius use daylight saving since 2008-11. 
The Olson database has been updated to reflect the Mauritius timezone change 
at the end of 2008 (maybe since tzdata-2008f or tzdata-2008g, not really 
sure).
Postgresql is supposed to have the correct Mauritius timezone since 8.3.5 
(http://www.postgresql.org/docs/8.3/interactive/release-8-3-5.html)
From a debian box configured in the Mauritius timezone :
$ date
Wed Mar  4 11:10:01 MUST 2009
$ psql -c "SELECT '2009-01-01 00:56:00 MUT'::timestamp"
      timestamp
---------------------
 2009-01-01 00:56:00
(1 row)
$ psql -c "SELECT '2009-01-01 00:56:00 MUST'::timestamp"
ERROR:  invalid input syntax for type timestamp: "2009-01-01 00:56:00 MUST"
As you can see Posgresql does not recognize the "MUST" (Mauritius Summer 
Time).
For reference, here is the content of the tzdata file related to Mauritius :
# Rule	NAME	FROM	TO	TYPE	IN	ON	AT	SAVE	LETTER/S
Rule Mauritius	1982	only	-	Oct	10	0:00	1:00	S
Rule Mauritius	1983	only	-	Mar	21	0:00	0	-
Rule Mauritius	2008	max	-	Oct	lastSun	2:00s	1:00	S
Rule Mauritius	2009	max	-	Mar	lastSun	2:00s	0	-
# Zone	NAME		GMTOFF	RULES	FORMAT	[UNTIL]
Zone Indian/Mauritius	3:50:00 -	LMT	1907		# Port Louis
			4:00 Mauritius	MU%sT	# Mauritius Time
Is this a bug in Posgresql or am I missing something ?
This problem was encountered with Postgresql 8.3.5 and 8.3.6.
Regards.
-- 
Xavier Bugaud
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2009-03-04 09:19:49 | Re: Date/time of last commit | 
| Previous Message | Michelle Konzack | 2009-03-04 06:58:14 | Re: pgsql announce now on twitter |