#729107 PRAGMA foreign_keys=ON doesn't work

Package:
libghc-hdbc-sqlite3-dev
Source:
hdbc-sqlite3
Description:
Sqlite v3 HDBC (Haskell Database Connectivity) Driver for GHC
Submitter:
Matt Kraai
Date:
2013-11-11 10:36:05 UTC
Severity:
minor
#729107#5
Date:
2013-11-09 06:10:09 UTC
From:
To:
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.
#729107#12
Date:
2013-11-09 08:05:43 UTC
From:
To:
Dear Matt,

Am Freitag, den 08.11.2013, 22:10 -0800 schrieb Matt Kraai:

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).

Greetings,
Joachim
#729107#19
Date:
2013-11-10 15:30:42 UTC
From:
To:
Hi,

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.