On 7/9/2013 8:50 AM, Roland Wilczek wrote:
- The order of execution of ON DELETE action is not well documented.
As far as I can tell, it's unspecified, subject to change without notice, and should be treated as unpredictable. If you want a deterministic order, create a single ON DELETE trigger that executes several statements in the desired order.
- If two foreign keys come into conflict, SQLite silently ignores one of them instead of raising an error.
So don't create two foreign keys that come into conflict. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users