Re: Enabling the foreign key support in Sliqte3

[Ryan Pusztai <rpusztai@...>]

On Sun, Mar 13, 2011 at 2:39 PM, Petite Abeille <petite.abeille@gmail.com> wrote:

On Mar 13, 2011, at 7:24 PM, Luciano de Souza wrote:

> For these reasons, I also believe the problem is in Luasql-sqlite3 and not in Sqlite3.

Not sure if this is the same issue, but you might want to update LuaSQL's sqlite3 driver to use sqlite3_prepare_v2 instead of the old sqlite3_prepare.

http://www.sqlite.org/capi3ref.html#sqlite3_prepare

In ls_sqlite3.c, line 350:

        res = sqlite3_prepare_v2(conn->sql_conn, statement, -1, &vm, &tail);

Note the '_v2' suffix to 'sqlite3_prepare'.

FWIW, I'm happily using LuaSQL and SQLite 3.7.5 with foreign constraints.

I hate bringing this old message up again, but I just got bit by this today. Can we please get this fix into the official luasql-sqlite3 module. I am willing to install the cvs rock to get this fix. Any help?

I am using LauSql-sqlite3 v2.3.0 using sqlite3 v3.7.13.

--

Regards,
Ryan