Thread: Patch for the MUST time zone (Mauritius Summer Time)

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
 

Xavier Bugaud wrote:
> This trivial patch allows PostgreSQL to understand the MUST (Mauritius Summer 
> Time) time zone that is in used since 2008-11.
> 
> ...
> 
> *** 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)

Shouldn't that new line be "MUST" then?

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com

On Thursday 05 March 2009 12:31:17 Heikki Linnakangas wrote:
> Xavier Bugaud wrote:
> > This trivial patch allows PostgreSQL to understand the MUST (Mauritius
> > Summer Time) time zone that is in used since 2008-11.
> >
> > ...
> >
> > *** 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)
>
> Shouldn't that new line be "MUST" then?

My mistake, sorry...

Please find bellow the new patches.


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:34:31 -0000
***************
*** 640,645 ****
--- 640,647 ----                  #     (Indian/Chagos) MUT     14400    # Mauritius Island Time                  #
(Indian/Mauritius)
+ MUST    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:37:12 -0000
***************
*** 27,32 ****
--- 27,34 ----                  #     (Indian/Chagos) MUT     14400    # Mauritius Island Time                  #
(Indian/Mauritius)
+ MUST    18000 D  # Mauritius Island Summer Time
+                  #     (Indian/Mauritius) MVT     18000    # Maldives Island Time                  #
(Indian/Maldives)RET     14400    # Reunion Time
 

Xavier Bugaud wrote:
> On Thursday 05 March 2009 12:31:17 Heikki Linnakangas wrote:
>> Xavier Bugaud wrote:
>>> This trivial patch allows PostgreSQL to understand the MUST (Mauritius
>>> Summer Time) time zone that is in used since 2008-11.
>>>
>>> ...
>>>
>>> *** 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)
>> Shouldn't that new line be "MUST" then?
> 
> My mistake, sorry...
> 
> Please find bellow the new patches.

Thanks! Committed.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com