Re: Problem with Zope 2.13.15, python 2.6.6 psycopg2-2.4.5, pg 9.0.3

We had the exact same problem with psycopg2/zope2.10/pg9 but could not find a satisfactory solution.

There are no problems with psycopg1 apart from it being old and unsupported :)

Rich

Richard Harley
Technical Director
(0044) 01522 837264 | http://www.scholarpack.com

On 03/08/12 14:33, Lutz Steinborn wrote:

Hi,

it is impossible to INSERT or UPDATE with ZSQL from external methods. The first
statement after a INSERT/UPDATE ends with an ROLLBACK.

Example:
2012-08-03 14:58:16.821 CEST [14542][501bca30.38ce][0] pre2@4com20110627_utf8
LOG:  statement: BEGIN 
2012-08-03 14:58:16.821 CEST [14542][501bca30.38ce][0]
pre2@4com20110627_utf8 LOG:  duration: 0.021 ms 
2012-08-03 14:58:16.821 CEST [14542][501bca30.38ce][0] pre2@4com20110627_utf8
LOG:  statement: update ADRE set modified_at= '120803145816', modified_by_user=
'l.steinborn@', modified_by_meth= 'update_IndiAdre',   mail1 =
'l.steinborn@4c-ag.de', /* Individuum.py (3) */ FirstName = 'Lutz', Last_entry
= '0001~000000000000' /* Serge.py (1) */ where login = '*******' AND password =
'******' AND Mail1 = 'l.steinborn@4c-ag.de' 
2012-08-03 14:58:16.822 CEST [14542] [501bca30.38ce][0] pre2@4com20110627_utf8
LOG:  duration: 0.273 ms 
2012-08-03 14:58:16.823 CEST [14542][501bca30.38ce][0] pre2@4com20110627_utf8
LOG: statement: SHOW default_transaction_isolation 
2012-08-03 14:58:16.823 CEST [14542] [501bca30.38ce][0] pre2@4com20110627_utf8
LOG:  duration: 0.034 ms 
2012-08-03 14:58:16.823 CEST [14542][501bca30.38ce][0] pre2@4com20110627_utf8
LOG: statement: ROLLBACK

Any idea whats going on?