[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.

http://bugs.python.org/

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


-- 

http://www.voidspace.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