Re: Problem with Mauritius summer time (MUST)

From: Xavier Bugaud <xavier(dot)bugaud(at)gloptv(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>
Subject: Re: Problem with Mauritius summer time (MUST)
Date: 2009-03-05 06:57:54
Message-ID: 200903051157.54518.xavier.bugaud@gloptv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 04 March 2009 16:32:27 Gregory Stark wrote:
> Xavier Bugaud <xavier(dot)bugaud(at)gloptv(dot)com> writes:
> >
> > $ psql -c "SELECT '2009-01-01 00:56:00 MUST'::timestamp"
> > ERROR: invalid input syntax for type timestamp: "2009-01-01 00:56:00
> > MUST"
>
> I think the problem is that MUST is missing from the Default
> timezone_abbreviations file.

Gregory you're right : it works after adding MUST in timezone/tznames/Default.

I will propose a patch in pgsql-hackers.

Thanks.
--
Xavier Bugaud

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2009-03-05 07:24:17 Re: Postgres Cookbook
Previous Message Greg Smith 2009-03-05 06:25:52 Re: Postgres Cookbook