Skip site navigation (1) Skip section navigation (2)

Re: ZPsycopgDA Isolation Levels Bug

From: Federico Di Gregorio <federico(dot)digregorio(at)dndg(dot)it>
To: psycopg(at)postgresql(dot)org
Subject: Re: ZPsycopgDA Isolation Levels Bug
Date: 2011-08-09 18:38:12
Message-ID: 4E417E94.5070504@dndg.it (view raw or flat)
Thread:
Lists: psycopg
On 09/08/11 20:16, Lex Berezhny wrote:
> Hi,
> 
> We have a pretty large Zope application that completely stopped
> working (no transactions were being commited) after upgrading from
> psycopg 2.4.1 to 2.4.2.
> 
> When I create the ZPsycopgDA adapter in the ZMI using Autocommit (via
> the patch I submitted) as the Isolation Level it starts working again.
> 
> I think it would be useful to have all of the available isolation
> levels in the drop down since they are all described in the API.
> 
> In our case, our application doesn't work at all without Autocommit.
> ZSQL methods never commit. Even when using the database adapter "Test"
> tab to run ad hoc queries all of them rollback.

So, you're saying that psycopg 2.4.2 is broken (vs Zope) and that the
right way to fix it is to add autocommit (i.e., if the page fails your
changes are committed to the database anyway). I'm, not sure I like
that. ;) We'll try to fix the Zope problem before 2.4.3 release.

In the meantime, thanks for the patch.

federico

-- 
Federico Di Gregorio                         federico(dot)digregorio(at)dndg(dot)it
Studio Associato Di Nunzio e Di Gregorio                  http://dndg.it
  Gli avvoltoi cinesi si nutrono di arte, ma possono anche mangiare
   i `domani'.                                        -- Haruki Murakami

In response to

psycopg by date

Next:From: Karsten HilbertDate: 2011-08-09 19:39:45
Subject: Re: ZPsycopgDA Isolation Levels Bug
Previous:From: Lex BerezhnyDate: 2011-08-09 18:16:39
Subject: Re: ZPsycopgDA Isolation Levels Bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group