SQLite Forum

Recursive TRIGGER stopping on reference to same table
Login
With `pragma recursive_triggers=1` everything works flawlessly. Thanks a lot! I hadn't even thought about PRAGMAs...

> As an aside, can you please use proper quotes?

I sure can. Thanks for making me aware of my quote-abuse :-)

P.S.: I think it might be a good idea to link the info about `recursive_triggers` on https://sqlite.org/lang_createtrigger.html . This way I would have found the solution myself when I searched the page for "recurs*".