Chuck Lima 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?
I need to know if I should continue to test/debug my constraint syntax
or get the right version of sqlite.
I also compiled and installed from a CVS checkout with the same results.
Thanks in advance for any help.
-Chuck
Chuck
Try using the which command to determine which copy of sqlite ou are
actually running.
which sqlite3
It will return the path to the binary it is executing. I suspect you
have another version (3.1.4) of sqlite installed that is being located
first.
HTH
Dennis Cote
