Re: Enabling the foreign key support in Sliqte3 [sic]

[Drake Wilson <drake@...>]

Quoth Luciano de Souza <luchyanus@gmail.com>, on 2011-03-12 21:20:47 -0300:
> function annotation:__init()
> obj = self
> self.env = luasql.sqlite3()
> self.con = self.env:connect(filename)
> self.cur = self.con:execute('select * from annotation_master')
> end

Aside from the versioning bit someone else mentioned, I don't see a
PRAGMA foreign_keys anywhere in there.  That pragma is not persistent
between database connections; you must set it for each connection.
(It's a client-specific behavior, not a database-wide one.)

   ---> Drake Wilson