From: | Richard Harley <richard(at)scholarpack(dot)com> |
---|---|
To: | psycopg(at)postgresql(dot)org |
Subject: | Re: Problem with Zope 2.13.15, python 2.6.6 psycopg2-2.4.5, pg 9.0.3 |
Date: | 2012-08-03 13:42:04 |
Message-ID: | 501BD52C.2050309@scholarpack.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
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(at)4com20110627_utf8
> LOG: statement: BEGIN
> 2012-08-03 14:58:16.821 CEST [14542][501bca30.38ce][0]
> pre2(at)4com20110627_utf8 LOG: duration: 0.021 ms
> 2012-08-03 14:58:16.821 CEST [14542][501bca30.38ce][0] pre2(at)4com20110627_utf8
> LOG: statement: update ADRE set modified_at= '120803145816', modified_by_user=
> 'l.steinborn@', modified_by_meth= 'update_IndiAdre', mail1 =
> 'l(dot)steinborn(at)4c-ag(dot)de', /* Individuum.py (3) */ FirstName = 'Lutz', Last_entry
> = '0001~000000000000' /* Serge.py (1) */ where login = '*******' AND password =
> '******' AND Mail1 = 'l(dot)steinborn(at)4c-ag(dot)de'
> 2012-08-03 14:58:16.822 CEST [14542] [501bca30.38ce][0] pre2(at)4com20110627_utf8
> LOG: duration: 0.273 ms
> 2012-08-03 14:58:16.823 CEST [14542][501bca30.38ce][0] pre2(at)4com20110627_utf8
> LOG: statement: SHOW default_transaction_isolation
> 2012-08-03 14:58:16.823 CEST [14542] [501bca30.38ce][0] pre2(at)4com20110627_utf8
> LOG: duration: 0.034 ms
> 2012-08-03 14:58:16.823 CEST [14542][501bca30.38ce][0] pre2(at)4com20110627_utf8
> LOG: statement: ROLLBACK
>
> Any idea whats going on?
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Kreen | 2012-08-07 10:51:04 | Re: libpq custom row processing |
Previous Message | Lutz Steinborn | 2012-08-03 13:33:40 | Problem with Zope 2.13.15, python 2.6.6 psycopg2-2.4.5, pg 9.0.3 |