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

Matt Kraai kraai at ftbfs.org
Sat Nov 9 06:10:09 UTC 2013

Package: libghc-hdbc-sqlite3-dev


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.


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

More information about the Pkg-haskell-maintainers mailing list