Skip site navigation (1) Skip section navigation (2)

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

From: "Pedro Alves" <pedro(at)neraka(dot)no-ip(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4073: ERROR: invalid input syntax for type timestamp: "Sat Mar 29 04:47:06 WEST 2008"
Date: 2008-03-31 19:25:13
Message-ID: 200803311925.m2VJPDbX041672@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4073
Logged by:          Pedro Alves
Email address:      pedro(at)neraka(dot)no-ip(dot)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

Responses

pgsql-bugs by date

Next:From: Lars OlsonDate: 2008-03-31 20:55:48
Subject: BUG #4074: Using SESSION_USER or CURRENT_USER in a view definition is unsafe
Previous:From: Chris BrowneDate: 2008-03-31 15:48:05
Subject: Re: BUG #4069: Wrong tip

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group