The following bug has been logged online: Bug reference: 4073 Logged by: Pedro Alves Email address: [EMAIL PROTECTED] 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
