Re: PostgreSQL Exception: invalid input syntax for type timestamp

Adam Tauno Williams <[email protected]> Mon, 16 Feb 2009 16:44:39 -0500
Newsgroups gmane.comp.cms.opengroupware.user
Message-ID <1234820679.5362.127.camel@linux-m3mt>
On Mon, 2009-02-16 at 18:05 +0100, Sven Arnold wrote:
> > Seems complicated (but all Debian/Ubuntu packaging is);  but libobjc-4.3
> > should be fine.  I've no idea what the "gobjc" package is.
> ok, maybe I referenced the wrong package. But there is also
> libobjc2-4.3.2.
> > > and compiled from source only these packages:
> > > - gnustep-make-1.10.
> > Do you mean ogo_gnustep-make?  The gnustep-make that came from the
> > download site?
> yes:
> http://download.opengroupware.org/nightly/sources/trunk/gnustep-make-latest.tar.gz
> > > - libfoundation
> > > - sope
> > > - sope-mod_ngobjweb
> > > - opengroupware.org
> > Correct.  I assume libfoundation is libfoundation11-1.1.7 or the like.
> yes, at least the last entry in the ChangeLog says this.
> > > 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?
> No, today I have repeated all steps on a fresh installation in a virtual
> machine to reduce side effects. There is no other GNUStep package
> installed I am aware of.
> BTW, the postgres log shows an insert statement:
> INSERT INTO session_log (...) VALUES (..., "%Y-%m-%d...")

Correct, that's what I've seen before;  obviously the %Y-%m-%d should be
2009-02-16 but it isn't expanded, so it creates the error.  I don't
really know what to suggest;  debugging Obj-C runtime issues is pretty
far beyond my pay grade.

I have an Ubuntu VM floating around here somewhere that I'll test on
when I get a chance.  Otherwise, if a VM is what you want,  I can post a
working VM for you to download if you like?

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