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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Pedro Alves <pedro(at)neraka(dot)no-ip(dot)org>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4073: ERROR: invalid input syntax for type timestamp: "Sat Mar 29 04:47:06 WEST 2008"
Date: 2008-03-31 21:41:23
Message-ID: 24793.1206999683@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Heikki Linnakangas <heikki(at)enterprisedb(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-03-31 21:46:48 Re: BUG #4074: Using SESSION_USER or CURRENT_USER in a view definition is unsafe
Previous Message Heikki Linnakangas 2008-03-31 21:36:54 Re: BUG #4074: Using SESSION_USER or CURRENT_USER in a view definition is unsafe