Hi, if you are talking about a feature request: Oracle supports sql syntax to enable or disable a certain trigger (as opposed to all triggers as you suggested):
ALTER TRIGGER <trigger-name> DISABLE or ALTER TRIGGER <trigger-name> ENABLE This would be nice. Martin Michal Seliga schrieb: > hi > > attached is patch which will make temporary disable of triggers possible. i > tried it in my application with current data (many inserts in to various table > with many triggers on them, which are not meant to be run while importing > data). > it works and it changed running time from 62 seconds to 4, so i guess its > worth it > > i added new pragma DISABLE_TRIGGERS which can be set to 0 (default, everything > works) or 1 (function which returns triggers always returns empty list so none > will be called) > > honestly, i didn't spent too much time with learning sqlite sources, i just > made > quick hack which works for me, i hope i diidn't break anything. so i decided > to > share it. maybe one day this feature can get to official version too > > > > > ------------------------------------------------------------------------ > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
