[Zope-DB] Psycopg, Zope & Autocommit

Federico Di Gregorio fog@debian.org
Mon, 11 Nov 2002 14:14:46 +0100


Scavenging the mail folder uncovered Smith, Neil (Worcester)'s letter:
> > this is how it works and let me add that adding COMMIT at
> > the end of every SQL Method will badly confuse Zope's
> > transaction machinery.
> 
> I agree that putting a commit at the end of the statement is not what should
> be done.  However, why will it confuse Zope.  All the transaction machinery
> has to do is decide at the end of the transaction whether it has had any
> errors and needs to issue a rollback, or whether it has been successful and
> needs to do a commit.  If a commit or rollback has already been issued
> within the ZSQL statements, then the commit or rollback that gets issued by
> the transaction machinery will obviously only apply to anything after what
> was committed or rolled back by the application.  This might not be what the
> user wants (but equally it might be exactly what they want), but it isn't
> going to confuse anything.

ok, i obviously choosed the wrong term.

-- 
Federico Di Gregorio
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
  Those who do not study Lisp are doomed to reimplement it. Poorly.
                                     -- from Karl M. Hegbloom .signature