Re: [Python-Dev] sqlite, DDL, and transactions

2010-12-20 Thread Scott Urban
On Mon, Dec 20, 2010 at 17:03:51, Michael Foord sent: > On 20/12/2010 16:48, Scott Urban wrote: > >Hi > > > >The python sqlite module automatically commits open transactions > >when it encounters a DDL statement. This is unnecessary; DDL is > >transaction in my testing (see attached). > > > > Hel

Re: [Python-Dev] sqlite, DDL, and transactions

2010-12-20 Thread Michael Foord
On 20/12/2010 16:48, Scott Urban wrote: Hi The python sqlite module automatically commits open transactions when it encounters a DDL statement. This is unnecessary; DDL is transaction in my testing (see attached). Hello Scott, Please post your patch to the Python bug tracker. http://bugs.p

Re: [Python-Dev] sqlite, DDL, and transactions

2010-12-20 Thread Brian Curtin
On Mon, Dec 20, 2010 at 10:48, Scott Urban wrote: > Hi > > The python sqlite module automatically commits open transactions > when it encounters a DDL statement. This is unnecessary; DDL is > transaction in my testing (see attached). > > Attached patch addresses the issue. Patch is against 2.6.1

[Python-Dev] sqlite, DDL, and transactions

2010-12-20 Thread Scott Urban
Hi The python sqlite module automatically commits open transactions when it encounters a DDL statement. This is unnecessary; DDL is transaction in my testing (see attached). Attached patch addresses the issue. Patch is against 2.6.1, but looking at Trunk in svn, it seems like the patch is needed