On 12 Mar 2020, at 3:36pm, David Blake <davebl...@kodi.tv> wrote: > What stops the > UPDATE ports SET timeofday = CURRENT_TIMESTAMP WHERE id = NEW.id ; > from also triggering the AFTER UPDATE ON recursively? > > Perhaps a pragma or inSQLite are triggers non-recursive by default?
Bingo. <https://sqlite.org/pragma.html#pragma_recursive_triggers> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
