On 21 Sep 2015, at 12:21am, James Hartley <jjhartley at gmail.com> wrote:
> I am assuming that dropping the trigger > will re-enable any action which had been disabled by creating the trigger. > > Is this incorrect? Nope. That's one way to do it. Another is to set "PRAGMA recursive_triggers = OFF" then have a TRIGGER make changes to the table. Simon.