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
Pardon. We have to also remove sqlite version or change it to something apropriate. --- ./src/global/dict_sqlite.c.orig 2010-08-03 17:37:29.000000000 +0400 +++ ./src/global/dict_sqlite.c 2010-08-03 17:37:48.000000000 +0400 @@ -67,10 +67,6 @@ #ifdef HAS_SQLITE #include <sqlite3.h> -#if !defined(SQLITE_VERSION_NUMBER) || (SQLITE_VERSION_NUMBER < 3005004) -#error "Your SQLite version is too old" -#endif - /* Utility library. */ #include <msg.h> @@ -200,7 +196,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,