This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

Author scott.urban
Recipients scott.urban
Date 2010-12-20.18:02:11
SpamBayes Score 7.208045e-06
Marked as misclassified No
Message-id <1292868135.81.0.257293444934.issue10740@psf.upfronthosting.co.za>
In-reply-to
Content
The python sqlite module automatically commits open transactions
when it encounters a DDL statement.  This is unnecessary; DDL is
transactional 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).

Patch also allows pragma statement.
History
Date User Action Args
2010-12-20 18:02:16scott.urbansetrecipients: + scott.urban
2010-12-20 18:02:15scott.urbansetmessageid: <1292868135.81.0.257293444934.issue10740@psf.upfronthosting.co.za>
2010-12-20 18:02:11scott.urbanlinkissue10740 messages
2010-12-20 18:02:11scott.urbancreate