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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers