[Zope-DB] Psycopg & refreshing products

[Andrew Veitch]

I've got a Python product that makes use of a psycopg adaptor and ZSQL
methods.

I've found that every time I refresh the product another connection to
postgres is opened and never closes - and after a few hours of coding this
bring Postgres to a halt as I reach the maximum number of connections. If I
restart Zope everything's fine.

This isn't a major problem for us because of course we don't refresh on the
live system very often but it's irritating.

Any ideas?

A

-- 
Logical Progression Ltd, 16 Forth Street, Edinburgh EH1 3LH, UK
Tel: +44 (0)131 466 9585 Web: http://www.logicalprogression.net/