this Postgres adapter is not multithreaded, check out the ZPoPyDA from zope.org. That is an alternative Postgres adapter that is multithreaded and does not lock up. phil *********** REPLY SEPARATOR *********** On 11.10.2000 at 08:48 Mark Twiddy wrote:
Hi thanks for the reply The problem is whenever i do really big query everything stops and waits.
im using ZPyGreSQLDA-0.3-rjr2 and py-PyGreSQL-2.4
thanks Mark On Tue, 10 Oct 2000, Mike Renfro wrote:
On Tue, Oct 10, 2000 at 04:58:46PM +0930, Mark Twiddy wrote:
Can someone please tell me what is going on. while querying a postgres database i am unable to access any crap from zope. I have tried creating a db connection in a enternal method and querying through that but it still locks and wont serve any requests.
Don't know if this will help, but my Zope/Postgresql experience has gone remarkably well.
I have the following packages installed on an otherwise regular Debian 2.2 machine:
libpgsql2 7.0.2-6 Shared library libpq.so.2 for PostgreSQL postgresql 7.0.2-6 Object-relational SQL database, descended fr postgresql-client 7.0.2-6 Front-end programs for PostgreSQL postgresql-dev 7.0.2-6 Header files for libpq (postgresql library) postgresql-doc 7.0.2-6 Documentation for the PostgreSQL database. python-pygresql 7.0.2-6 PostgreSQL module for Python zope 2.2.2-1 The Z Object Publishing Environment zope-pygresqlda 0.3rjr2-1 A Zope Database Adapter for PostgreSQL
Between those packages, following the PostgreSQL tutorial at postgresql.org, and following the Z SQL Methods User's Guide (http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.html), I'm working fine. Where are the actual errors?
-- Mike Renfro / R&D Engineer, Center for Manufacturing Research, 931 372-3601 / Tennessee Technological University -- renfro@tntech.edu
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )