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
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 |