[Python-Dev] sqlite, DDL, and transactions

Brian Curtin brian.curtin at gmail.com
Mon Dec 20 18:03:23 CET 2010


On Mon, Dec 20, 2010 at 10:48, Scott Urban <scott.urban at isilon.com> 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, but
> looking at Trunk in svn, it seems like the patch is needed and
> would apply. One issue I could foresee is that this behavior might
> depend on the sqlite version in use (I'm on 3.6.10).
>
> Thanks
> Scott


Can you submit this to bugs.python.org? Bug reports and their patches on the
mailing list tend to get lost.

Additionally, 2.7 would be the 2.x version to fix this against
(branches/release27-maint when looking in svn).
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-dev/attachments/20101220/2b81e2d8/attachment.html>


More information about the Python-Dev mailing list