Hi. There was a ticket about uninformative error message on check constraint failures - http://www.sqlite.org/src/tktview/23b212820161c6599cbf414aa99bf8a5bfa5e7a3 (It's market as Fixed on 2014-03-11 in version 3.3.2). But for foreign key we still have uninformative error messages - "FOREIGN KEY constraint failed".
Is there any chance to see it's implemented in SQLite some time? It's absolute a must have feature. I understand that collecting additional info on FK violation can slow down execution. So it could be disable by default and enabled with some Pragma. Currently It's impossible to correctly process such messages in libraries and apps to report some meaningfull info to user. As it's unclear what is going on.
