View Single Post

   
  #8 (permalink)  
Old 04-12-2008, 06:59 AM
Joachim Wieland
 
Posts: n/a
Default Re: invalid input syntax for type timestamp.

On Fri, Dec 15, 2006 at 10:17:20AM -0500, Tom Lane wrote:
> >> However, I encounter the problem of timestamp.:-(
> >> Was anyone recognizing this problem?


> > The list of accepted timezones is now configurable, check through the
> > docs how to find the list and set it the way you want.


> Yeah, but why the heck isn't JST in it by default? This seems to have
> slipped through the cracks, because I don't see it anywhere in any of
> the timezonesets/* files. Joachim?


Yes, it got removed, see

http://archives.postgresql.org/pgsql...7/msg00077.php

I checked each of the timezones I removed but I don't have my notes anymore
as to why I thought JST could be removed. Obviously, it shouldn't be
removed...

Appended is a patch that adds JST and JDT into Asia.txt and the Default set.


Joachim



---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Reply With Quote