[Pkg-haskell-maintainers] Bug#729107: PRAGMA foreign_keys=ON doesn't work

[Matt Kraai]

Package: libghc-hdbc-sqlite3-dev
Version: 2.3.3.0-3+b1

Hi,

Executing "PRAGMA foreign_keys=ON" using HDBC-sqlite3 doesn't enable
foreign key support, because HDBC-sqlite3 automatically starts a
transaction and "[i]t is not possible to enable or disable foreign key
constraints in the middle of a multi-statement transaction"[1].

It's possible to work around this by executing "COMMIT" or "ROLLBACK"
before the executing the pragma, but it would be nicer if the pragma
just worked.

-- 
Matt

1. http://sqlite.org/lang_transaction.html