Re: Fwd: odd transaction behavior

Federico Di Gregorio <fog-NGVKUo/i/[email protected]> Mon, 22 Mar 2010 19:10:48 +0100

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

On 22/03/2010 19:03, Kerri Reno wrote:
>> 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.

But I suppose that the interface knows what the user is doing. Just
commit after each select.

federico

-- 
Federico Di Gregorio                                       fog-NGVKUo/i/[email protected]
               Nice to meet you Rose... run for your life. -- The Doctor

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

signature.asc (application/pgp-signature, 262 B)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkunsqgACgkQvcCgrgZGjesPsQCgr+DP+FUCVaYp3IcxYpD2CyGx
gJsAnRxLI7ZoFcR8sFbseMT64wabqSHB
=osaP
-----END PGP SIGNATURE-----