[Zope] Problems with Postgres 7.0

Richard Taylor r.taylor@eris.dera.gov.uk
02 Jun 2000 14:33:41 +0100


I am having problems with the new release of Postgres (7.0). 

I have an application that has been connecting to a Postgres 6.5
database through ZPyGres without any problems. When I upgraded to 7.0
the query hangs the database connection and zope. Zope will not
respond to any requests until I manually kill the 'postgres' process
that is doing the query.

I can issue the query direct to postgres through the command line
without a problem.

I thought this might be something to do with ZPyGres not being thread
safe but I get the same results even if I force zope to only run 1
thread.

Has anyone else seen problems with ZPyGres and Postgres 7.0?

For now I have had to revert to Postgres 6.5.

I did see some discussion on this list recently about something called
ZPoPyDA but I can find no reference to it on the Zope web site. If
this is a development of a new Postgres DA I would be very interested
to see if it solves my problem, can anyone advice?

Many thanks

Richard