> run in a transaction Or just use PL/pgSQL stored functions which are inherently transactions[1] No bad thing anyway as it has a side-benefit of helping the

> run in a transaction Or just use PL/pgSQL stored functions which are inherently transactions[1] No bad thing anyway as it has a side-benefit of helping the fight against SQL injection attacks etc. [1] https://www.postgresql.org/docs/14/plpgsql-transactions.html https://www.postgresql.org/docs/14/plpgsql-transactions.html