[sqlalchemy] Re: Newbie question about transactions

2007-07-29 Thread mc
Thanks again. Let me see if I understood this correctly. What I tried to do initially is use implicit connections that I have no control over. The transaction was started on my explicit connection but the inserts used a different connection from the pool and therefore were not aware of the

[sqlalchemy] Re: Newbie question about transactions

2007-07-29 Thread Michael Bayer
On Jul 29, 2007, at 7:54 AM, mc wrote: Thanks again. Let me see if I understood this correctly. What I tried to do initially is use implicit connections that I have no control over. The transaction was started on my explicit connection but the inserts used a different connection from the

[sqlalchemy] Re: Newbie question about transactions

2007-07-28 Thread mc
Thanks. Can you point me to the place in the doc where this is discussed? I was under the impression that I had one connection only in this scenario. TIA On Jul 28, 11:09 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Jul 28, 2007, at 2:54 PM, mc wrote: md=BoundMetaData(db)

[sqlalchemy] Re: Newbie question about transactions

2007-07-28 Thread Michael Bayer
discussion starts here: http://www.sqlalchemy.org/docs/dbengine.html#dbengine_connections covers some options available to you including using a thread local connection. On Jul 28, 2007, at 5:07 PM, mc wrote: Thanks. Can you point me to the place in the doc where this is discussed? I