Hi, On Sat, Nov 09, 2013 at 09:05:43AM +0100, Joachim Breitner wrote: > Am Freitag, den 08.11.2013, 22:10 -0800 schrieb Matt Kraai: > > 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. > > thanks for the report. This is an upstream, and upstream hasn’t been > particularly active in recent years. hdbi-sqlite (not yet packaged for > Debian) is an unofficial successor; you might want to investigate > whether that suits your purposes better (and if so, I’d like to hear > about it).
Thank you for the information. I've ported my application to HDBI, and it seems to work OK. In particular, the pragma works without requiring a workaround. I've started looking into packaging HDBI and its dependencies for Debian. -- Matt -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
