Sqlite Dog wrote: > seems like SQLite is not checking trigger SQL for invalid column names > until execution?
No. > Is there a way to force this check? Not without compiling the respective INSERT/UPDATE/DELETE statement. > The problem: trying to find out which indices, triggers and views depend on > particular column. We can recreate table without this column and recompile > indices, triggers and views. SQLite does not have a "compiled" state that is exposed to the application. What you could do is to try to run EXPLAIN QUERY PLAN on some triggering statement. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
