[Zope] Problems with Zope and SQL methods

[Neil McIntosh]

Hello all,

I have recently upgraded and moved a zope server to 2.3.2.  This has proved
a difficult task as we are using it to access an intranet database running
on Postgresql back end.  Whenever a query is run where an oid is returned it
hangs the ZServer and core dumps.

eg
select * from people
OR
select p.oid, p.name from people p

This can be avoided by setting the type as follows.

select p.oid::int, p.name from people p

However the following will still cause a core dump

select p.oid::int, p.* from people p.

I have noticed that others have been having similar problems but not seen
any solutions on this list.

I am using the following

ZPoPyDA 1.2
ZSQLMethods 1.2.1

and quite a lot else.

postgres 7.1-1 for reference.

Thanks,

Neil McIntosh
IT Manager
Sentec Ltd.