Patch for the MUST time zone (Mauritius Summer Time)

Started by Xavier Bugaudalmost 17 years ago4 messages

xavier.bugaud@gloptv.com

almost 17 years ago

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

Heikki Linnakangas

heikki.linnakangas@enterprisedb.com

almost 17 years ago

In reply to: Xavier Bugaud (#1)

Re: Patch for the MUST time zone (Mauritius Summer 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

Xavier Bugaud

xavier.bugaud@gloptv.com

almost 17 years ago

In reply to: Heikki Linnakangas (#2)

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

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

Heikki Linnakangas

heikki.linnakangas@enterprisedb.com

almost 17 years ago

In reply to: Xavier Bugaud (#3)

Re: Patch for the MUST time zone (Mauritius Summer 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