[Python-Dev] sqlite, DDL, and transactions

Michael Foord fuzzyman at voidspace.org.uk
Mon Dec 20 18:03:51 CET 2010

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.


All the best,

Michael Foord

> 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
> _______________________________________________
> Python-Dev mailing list
> Python-Dev at python.org
> http://mail.python.org/mailman/listinfo/python-dev
> Unsubscribe:http://mail.python.org/mailman/options/python-dev/fuzzyman%40voidspace.org.uk



May you do good and not evil
May you find forgiveness for yourself and forgive others
May you share freely, never taking more than you give.
-- the sqlite blessinghttp://www.sqlite.org/different.html

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-dev/attachments/20101220/b73e3c3d/attachment.html>

More information about the Python-Dev mailing list