Blogmark
Trigger recursion in PostgreSQL and how to deal with it
via jbranchaud@gmail.com
https://www.cybertec-postgresql.com/en/dealing-with-trigger-recursion-in-postgresql/
PostgreSQL
Triggers
This article walks through a couple examples of where infinite trigger recursion can happen if we’re not careful about when we’re updating and under what conditions.
I learned a few new things including the function for getting the current trigger depth and that a trigger definition can include a when clause so that it conditionally runs.
Great article, very approachable.