On Fri, Aug 19, 2011 at 4:19 PM, Boris Kolpackov <bo...@codesynthesis.com>wrote:
> In this simple case, yes. However, I need to support multiple levels > of references which makes creating "perfect" DROP order difficult or > even impossible (e.g., if there are cycles). > > Maybe (and i'm just guessing here) disabling/re-enabling foreign keys before/after the drop? Ah, the docs say: http://www.sqlite.org/foreignkeys.html It is not possible to enable or disable foreign key constraints in the middle of a multi-statement transaction<http://www.sqlite.org/lang_transaction.html> (when SQLite is not in autocommit mode<http://www.sqlite.org/c3ref/get_autocommit.html>). Attempting to do so does not return an error; it simply has no effect. so the pragma switch would have to come before/after the transaction, as opposed to being part of it. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users