Re: PostgreSQL Exception: invalid input syntax for type timestamp

Sven Arnold <[email protected]> Tue, 17 Feb 2009 01:45:45 +0100
Newsgroups gmane.comp.cms.opengroupware.user
Message-ID <1234831545.5749.25.camel@schnuppe>
> No, it should be updated to lF head. Or in other words: do not use the  
> embedded libFoundation ;-)

I guessed so, but it did not change the behaviour... :-(

BTW, there is a strange #if macro in NSCalendarDate+PGVal.m:

--->
#if 0
  format = [_attribute calendarFormat];
#else /* hm, why is that? */
  format = @"%Y-%m-%d %H:%M:%S%z";
#endif
<---

and in EOAttribute+PostgreSQL72.m there are some lines where I would expect PGSQL_TIMESTAMP_FORMAT:

--->
case TIMESTAMPOID:
      [self setExternalType:@"timestamp"];
      [self setValueClassName:@"NSCalendarDate"];
      [self setCalendarFormat:PGSQL_DATETIME_FORMAT];
      break;
case TIMESTAMPTZOID:
      [self setExternalType:@"timestamptz"];
      [self setValueClassName:@"NSCalendarDate"];
      [self setCalendarFormat:PGSQL_DATETIME_FORMAT];
      break;
<---

Not that I would know what I am talking about...

-Sven

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users