[Zope-DB] Re: Trying to catching ZPsycopg exceptions aborts the transaction

Federico Di Gregorio fog at initd.org
Wed Dec 1 13:14:24 EST 2004


Il giorno mer, 01-12-2004 alle 17:04 +0100, Dieter Maurer ha scritto:
[snip]
> However, I have observed an "auto-abort" behaviour of Postgres
> (via "psycopg"): when an error occurred, Postgres refused
> to do any more commands until the transaction was explicitely
> aborted.

a long time ago psycopg offered an auto-rollback feature that would have
helped to be able to re-initiate a transaction in an except clause and
commit at least some (or all, by redoing the entire transaction) data. a
lot of users complained and i agreed that that behaviour was bad.

but what people using psycopg with zope do think about that? i will
never add that back to psycopg, but adding it to zpsycopgda is an
option.

federico




More information about the Zope-DB mailing list