Re: PostgreSQL Exception: invalid input syntax for type timestamp

Helge Hess <[email protected]> Tue, 17 Feb 2009 14:31:08 +0100
Newsgroups gmane.comp.cms.opengroupware.user
Message-ID <[email protected]>
On 17.02.2009, at 01:45, Sven Arnold wrote:
> BTW, there is a strange #if macro in NSCalendarDate+PGVal.m:


Yes, I think the timezone format is hardcoded in some places. That  
should be fixed (I guess there is no reason to treat a timestamp as a  
string and then parse it ...).

The find out who triggers the code section, you would need to start  
OGo in GDB and put a breakpoint on -raise, eg:

   gdb /usr/local/sbin/ogo-webui-1.1
   break -raise
   r -WOUseWatchDog NO

I guess that your PG (or OGo) runs in a German locale, hence the date  
format is probably different. Something like this:

   export LANG=en_US

prior starting OGo/PG might help, not sure.

Greets,
   Helge
-- 
Helge Hess
http://helgehess.eu/
-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users