4 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: Simple transactions
FromSent OnAttachments
Miki17 Jan 2007 15:57 
Jonathan Ellis18 Jan 2007 08:39 
Michael Bayer18 Jan 2007 10:04 
Michael Bayer18 Jan 2007 10:15 
Subject:[sqlalchemy] Re: Simple transactions
From:Jonathan Ellis (jona@utahpython.org)
Date:01/18/2007 08:39:55 AM
List:com.googlegroups.sqlalchemy

On 1/17/07, Miki <miki@gmail.com> wrote:

# Notice we didn't commit yet This means that if someone is querying the table in the middle of the transaction it'll get wrong results. (I'm not a DB expert, this might be total nonsense)

no, it just means that queries run in the same uncommitted transaction can see the uncommitted data. this is the way transactions are supposed to work; only connections _outside_ the transaction shouldn't be able to see it.