On 3/7/06, Chuck Lima <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I just compiled and installed sqlite-3.3.4 on FC4 and it seems to be
> running just fine, except for a few things.
>
> sqlite3 -version returns 3.1.4
>
> This in itself is not a problem, but I can't seem to get constraints
> to work and the documentation indicates that I need version >= 3.3 .
> Is the -version switch merely misreporting the real version number
> or does the sqlite-3.3.4.tar.gz file actually contain the 3.1.4 files?
There's another possibility. Have you ever had another version of sqlite
installed? Try writing a tiny program with the following, or its
equivalent, in it:
fprintf(stdout, "library info: %d %d\n",
SQLITE_VERSION_NUMBER,
sqlite3_libversion_number());
The first is the constant defined in the sqlite3.h file your program is
using. The second is the value of that constant that was compiled into the
library you're using. If they don't match, or if they don't match what
sqlite3 -version is reporting, then something's wrong with your installation
-- probably you have two copies of sqlite in different places.
- Pam
