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)

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.

Is there some way to get more details on what mismatched, such as
turning on a debug flag, upping verbosity, or using DBI's trace
mechanism (which I once used ages ok and remember as being meant for
DBI/DBD developers rather than mere SQL hackers :-)

-- 
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / fe...@crowfix.com
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to