[issue12997] sqlite3: PRAGMA foreign_keys = ON doesn't work

[Mark Bucciarelli]

New submission from Mark Bucciarelli <mark at crosscutmedia.com>:

If I read http://bugs.python.org/issue10740#msg132470 correctly, the foreign_keys PRAGMA is a no-op b/c "The python sqlite module automatically commits open transactions when it encounters a DDL statement."

Entering as a separate issue as I'm not sure solving 10740 is required to solve this one.

----------
components: None
files: t.py
messages: 144166
nosy: Mark.Bucciarelli
priority: normal
severity: normal
status: open
title: sqlite3: PRAGMA foreign_keys = ON doesn't work
type: behavior
versions: Python 2.7
Added file: http://bugs.python.org/file23177/t.py

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue12997>
_______________________________________