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

Pedro Alves wrote:

Since saturday Portugal is in WEST timezone. Some of my programs stopped
working. Those programs use the output of java.util.Date, and come out as
"Sat Mar 29 04:47:06 WEST 2008".

Though not everyone uses that kind of output in timezones, everyone that
uses a recent jvm and are in portugal, faroe island or canary island will
have issues with this. Ref:
http://www.timeanddate.com/library/abbreviations/timezones/eu/west.html

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.

I found a way to *hack* the solution by copying the file Portugal to WEST in
share/timezones

No need for such hacks, see:

http://www.postgresql.org/docs/8.3/interactive/datetime-config-files.html

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

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