On 10/14/2011 01:29 AM, fe...@crowfix.com wrote:
I'm working on a project which generates tables from a config file,
and it seems to be happy on a Mac OSX running 3.4.0, but Linux running
3.7.8 complains about an insert with the unhelpful message
(foreign key mismatch)
It means there is a problem with a foreign key definition in the
database schema. Either an FK specifies parent columns that do not
exist, or parent columns that are not a PRIMARY KEY or UNIQUE.
I've checked all the data and don't see what it is complaining about,
and if I dump the SQL to a file and execute the same commands that
way, it works, and so does adding the single record in question using
sqlite3.
Error message only shows up if foreign keys are enabled ("PRAGMA
foreign_keys = ON"). They are disabled by default.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
