The following bug has been logged online:
Bug reference: 4073
Logged by: Pedro Alves
Email address: pedro@neraka.no-ip.org
PostgreSQL version: 8.2.7
Operating system: Linux Slackware 11 and 12
Description: ERROR: invalid input syntax for type timestamp: "Sat
Mar 29 04:47:06 WEST 2008"
Details:
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
I found a way to *hack* the solution by copying the file Portugal to WEST in
share/timezones
Thanks