On Mon, 2 Aug 2010 14:36:35 -0400 (EDT), Wietse Venema <wie...@porcupine.org> wrote: > subscri...@viliar.net.ru: >> On Mon, 02 Aug 2010 09:02:41 -0400, Brian Evans - Postfix List >> <grkni...@scent-team.com> wrote: >> > On 8/2/2010 5:18 AM, subscri...@viliar.net.ru wrote: >> >> I use postfix with sqlite patch about 2 years with small fix to >> function >> >> name. I >> >> suggest to make something like this for postfix 2.8. Or maybe check >> >> sqlite >> >> version at compile time and use ifdef's. >> > >> > You might like this from the archives... >> > http://archives.neohapsis.com/archives/postfix/2010-06/0539.html >> >> Thank you. Do you think I should re-post it in that thread? I didn't find >> there any relevant posts to this problem. > > Especially if you can also post concrete code for solving this. > Otherwise, the Postfix xqlite driver is unlikely to change. > > Wietse
certainly. --- ./src/global/dict_sqlite.c.orig 2010-08-03 17:17:52.000000000 +0400 +++ ./src/global/dict_sqlite.c 2010-08-03 17:18:20.000000000 +0400 @@ -200,7 +200,7 @@ static const char *dict_sqlite_lookup(DI msg_info("%s: %s: Searching with query %s", myname, dict_sqlite->parser->name, vstring_str(query)); - if (sqlite3_prepare_v2(dict_sqlite->db, vstring_str(query), -1, + if (sqlite3_prepare(dict_sqlite->db, vstring_str(query), -1, &sql_stmt, &query_remainder) != SQLITE_OK) msg_fatal("%s: %s: SQL prepare failed: %s\n", myname, dict_sqlite->parser->name, :-)