Lists: | pgsql-hackers |
---|
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 |
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: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
---|---|
To: | Xavier Bugaud <xavier(dot)bugaud(at)gloptv(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Patch for the MUST time zone (Mauritius Summer Time) |
Date: | 2009-03-05 07:31:17 |
Message-ID: | 49AF7FC5.1080906@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
From: | Xavier Bugaud <xavier(dot)bugaud(at)gloptv(dot)com> |
---|---|
To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Patch for the MUST time zone (Mauritius Summer Time) |
Date: | 2009-03-05 07:39:33 |
Message-ID: | 200903051239.33444.xavier.bugaud@gloptv.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
---|---|
To: | Xavier Bugaud <xavier(dot)bugaud(at)gloptv(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Patch for the MUST time zone (Mauritius Summer Time) |
Date: | 2009-03-05 14:30:43 |
Message-ID: | 49AFE213.3020604@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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