[Python-Dev] sqlite, DDL, and transactions (original) (raw)

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