[Zope-DB] Psycopg, more errors

Charlie Clark charlie@begeistert.org
Sat, 09 Nov 2002 13:44:25 +0100


On 2002-11-09 at 10:58:23 [+0100], Charlie Clark wrote:
> Any ideas? It seems the problem is reproducible but seeing as it doesn't 
> give any traceback I don't know where to go looking for more info and who 
> to tell in case it really is a bug.

Something is definitely wrong with the setup of PostgreSQL on my server: it 
won't do OUTER JOINS. They work fine on my notebook and they are supported 
as far as I know.

I think the versions of psycopg and the DA are pretty much the same
psycopg is 1.0.12 on my notebook and 1.0.13 on the server
For the DA
'''$Id: db.py,v 1.29.2.6 2002/09/05 08:55:07 fog Exp $'''
__version__='$Revision: 1.29.2.6 $'[11:-2]      
on both

I'm stumped and will have to use a work-around otherwise.

Charlie

This is the SQL message:
Error, psycopg.IntegrityError: ERROR: OUTER JOIN is not yet supported

And this is the traceback

Traceback (innermost last):
  File 
/usr/local/httpd/vhosts/psytec/zope/lib/python/ZPublisher/Publish.py, line 
150, in publish_module
  File 
/usr/local/httpd/vhosts/psytec/zope/lib/python/ZPublisher/Publish.py, line 
114, in publish
  File /usr/local/httpd/vhosts/psytec/zope/lib/python/Zope/__init__.py, 
line 159, in zpublisher_exception_hook
    (Object: qPeople)
  File 
/usr/local/httpd/vhosts/psytec/zope/lib/python/ZPublisher/Publish.py, line 
98, in publish
  File /usr/local/httpd/vhosts/psytec/zope/lib/python/ZPublisher/mapply.py, 
line 88, in mapply
    (Object: manage_test)
  File 
/usr/local/httpd/vhosts/psytec/zope/lib/python/ZPublisher/Publish.py, line 
39, in call_object
    (Object: manage_test)
  File /usr/local/httpd/vhosts/psytec/zope/lib/python/Shared/DC/ZRDB/DA.py, 
line 328, in manage_test
    (Object: qPeople)
  File /usr/local/httpd/vhosts/psytec/zope/lib/python/Shared/DC/ZRDB/DA.py, 
line 306, in manage_test
    (Object: qPeople)
  File /usr/local/httpd/vhosts/psytec/zope/lib/python/Shared/DC/ZRDB/DA.py, 
line 421, in __call__
    (Object: qPeople)
  File 
/usr/local/httpd/vhosts/psytec/zope/lib/python/Products/ZPsycopgDA/db.py, 
line 201, in query
IntegrityError: (see above)