Re: Fwd: odd transaction behavior

Kerri Reno <[email protected]> Mon, 22 Mar 2010 12:03:34 -0600

Newsgroups	gmane.comp.python.db.psycopg.devel
Message-ID	<[email protected]>

On Mon, Mar 22, 2010 at 11:57 AM, Federico Di Gregorio <fog-NGVKUo/i/[email protected]>wrote:

> On 22/03/2010 18:44, Kerri Reno wrote:
> > Thanks for your response.  Do you suggest that I change the isolation
> level
> > back to READ COMMIT if I want to do multiple lines in a transaction?
>
> Yes. In fact unless you have a very specific problem, psycopg does quite
> a good job at starting transactions for you. Why you wanted autocommit,
> btw?
>
> federico
>
> --
> Federico Di Gregorio                                       fog-NGVKUo/i/[email protected]
>           The reverse side also has a reverse side.  -- Japanese proverb
>
> Because, with READ COMMIT, any command starts a transaction, so the user
may do many selects before the insert, update  or delete, (and then commit)
using the user interface.  So the transaction is out there that whole time.

Kerri

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg