Re: BUG #4073: ERROR: invalid input syntax for type timestamp: "Sat Mar 29 04:47:06 WEST 2008" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4073: ERROR: invalid input syntax for type timestamp: "Sat Mar 29 04:47:06 WEST 2008"
Date
Msg-id 24793.1206999683@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4073: ERROR: invalid input syntax for type timestamp: "Sat Mar 29 04:47:06 WEST 2008"  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-bugs
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Pedro Alves wrote:
>> Since saturday Portugal is in WEST timezone.

> We don't include all timezone abbreviations, because they're generally
> not well-defined. Not sure if that's the case with WEST, but it seems
> quite likely. We do have the abbreviation WETDST for that, though.

Yeah, it seems to have been left out of our default list of TZ
abbreviations, probably because it seemed way too likely to be
non-unique.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #4074: Using SESSION_USER or CURRENT_USER in a view definition is unsafe
Next
From: Tom Lane
Date:
Subject: Re: BUG #4074: Using SESSION_USER or CURRENT_USER in a view definition is unsafe