[Pkg-haskell-maintainers] Bug#729107: PRAGMA foreign_keys=ON doesn't work
kraai at ftbfs.org
Sat Nov 9 06:10:09 UTC 2013
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".
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
More information about the Pkg-haskell-maintainers