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 > >transa

[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