Patch for the MUST time zone (Mauritius Summer Time)

From: Xavier Bugaud <xavier(dot)bugaud(at)gloptv(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Patch for the MUST time zone (Mauritius Summer Time)
Date: 2009-03-05 07:10:21
Message-ID: 200903051210.21542.xavier.bugaud@gloptv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

This trivial patch allows PostgreSQL to understand the MUST (Mauritius Summer
Time) time zone that is in used since 2008-11.

Before the patch :
# SELECT '2009-03-15 14:54:15 MUST'::timestamp;
ERROR: invalid input syntax for type timestamp: "2009-03-15 14:54:15 MUST"

After the patch :
# SELECT '2009-03-15 14:54:15 MUST'::timestamp;
timestamp
---------------------
2009-03-15 14:54:15
(1 row)

Index: src/timezone/tznames/Default
===================================================================
RCS file: /projects/cvsroot/pgsql/src/timezone/tznames/Default,v
retrieving revision 1.6
diff -c -r1.6 Default
*** src/timezone/tznames/Default 1 May 2008 20:05:08 -0000 1.6
--- src/timezone/tznames/Default 5 Mar 2009 07:03:19 -0000
***************
*** 640,645 ****
--- 640,647 ----
# (Indian/Chagos)
MUT 14400 # Mauritius Island Time
# (Indian/Mauritius)
+ MUT 18000 D # Mauritius Island Summer Time
+ # (Indian/Mauritius)
MVT 18000 # Maldives Island Time
# (Indian/Maldives)
RET 14400 # Reunion Time

Index: src/timezone/tznames/Indian.txt
===================================================================
RCS file: /projects/cvsroot/pgsql/src/timezone/tznames/Indian.txt,v
retrieving revision 1.2
diff -c -r1.2 Indian.txt
*** src/timezone/tznames/Indian.txt 25 Jul 2006 13:49:21 -0000 1.2
--- src/timezone/tznames/Indian.txt 5 Mar 2009 07:05:35 -0000
***************
*** 27,32 ****
--- 27,34 ----
# (Indian/Chagos)
MUT 14400 # Mauritius Island Time
# (Indian/Mauritius)
+ MUT 18000 D # Mauritius Island Summer Time
+ # (Indian/Mauritius)
MVT 18000 # Maldives Island Time
# (Indian/Maldives)
RET 14400 # Reunion Time

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2009-03-05 07:24:27 Re: Updates of SE-PostgreSQL 8.4devel patches (r1668)
Previous Message KaiGai Kohei 2009-03-05 06:17:26 Re: [BUG] Column-level privileges on inherited tables