Re: PostgreSQL Exception: invalid input syntax for type timestamp

> > Did you install libobcj-lf?  If so you need to remove it and rebuild.
> > You must use the system libobj with SOPE47, and you must use SOPE47 with
> > the latest/trunk/1.1 OGo.  This is documented in WMOGAG
> > <http://docs.opengroupware.org/Members/whitemice/wmogag/file_view>.  See
> > the chapter "Installation").
> I use gobjc that comes with ubuntu:
> gobjc            4:4.3.1-1ubuntu2
> gobjc-4.3	 4.3.2-1ubuntu12                                      
> libobjc2         4.3.2-1ubuntu12 

Seems complicated (but all Debian/Ubuntu packaging is);  but libobjc-4.3
should be fine.  I've no idea what the "gobjc" package is.

> and compiled from source only these packages:
> - gnustep-make-1.10.0

Do you mean ogo_gnustep-make?  The gnustep-make that came from the
download site?

> - libfoundation
> - sope
> - sope-mod_ngobjweb
> - opengroupware.org

Correct.  I assume libfoundation is libfoundation11-1.1.7 or the like.

> > You do need to make a small change to the schema for PostgreSQL, this is
> > also covered in WMOGAG (see page 137 of the current WMOGAG).
> Thanks for pointing that out. I changed this but it had no effect to the
> timestamp exception.

No, it doesn't fix the timestamp issue;  it is just required to use 8.3
with OGo.  Between 8.3 and previous versions PostgreSQL changed how they
handle casting of value types.

> Does run ogo elswhere with postgresql-8.3 or on Ubuntu 8.10 ?

Yes, it runs on 8.3 here, and elsewhere.  I have no idea about Ubuntu
but it shouldn't matter - there is nothing magical about distributions,
just repackaging of the same stuff.  Both previously related issues with
the same error were the result of ABI/version issues I believe.  Do you
possibly have GNUStep stuff installed and something is picking that up
and linking to it?

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