Problem with Zope 2.13.15, python 2.6.6 psycopg2-2.4.5, pg 9.0.3
От | Lutz Steinborn |
---|---|
Тема | Problem with Zope 2.13.15, python 2.6.6 psycopg2-2.4.5, pg 9.0.3 |
Дата | |
Msg-id | 20120803153340.7fc8524d5a38e459f2f68907@4c-ag.de обсуждение исходный текст |
Ответы |
Re: Problem with Zope 2.13.15, python 2.6.6 psycopg2-2.4.5,
pg 9.0.3
|
Список | psycopg |
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? -- Lutz
В списке psycopg по дате отправления: