[OGo-Users] URLs Accessible from ZideStore
Adam Tauno Williams
users@opengroupware.org
Wed, 23 Apr 2008 13:32:06 -0400
> class:PostgreSQL72Exception reason:fatal pgsql error
> (channel=<0x0x84511b4[PostgreSQL72Channel]:
> connection=<0x0x8488964[PGConnection]: connection=0x0x84a7238>>):
> ERROR: syntax error at end of input
> LINE 1: ...ob_status <> '30_archived') AND (t1.executant_id IN
> 10100))
> I'll check into this.
> If you discover what is the problem, you say me it, please.
The SQL is missing the closing paren. I need to find and fix this in
the code, so the patch will be submitted upstream.
> It isn't the fastest thing in the world, but isn't terrible. Enabling
> profiling and seeing where the time goes would be useful (see WMOGAG).
> Often it is people having never performed a "VACUUM ANALYZE;" on their
> database. There is also a [undocumented] bulk get method which helps
> allot; with it you can retrieve multiple objects in a single request.
> I am going to review wmogag, Do you know what is the method?
You can set defaults that enable additional logging either outputting
the literal SQLs generated or that time the various Logic commands.