https://www.w3resource.com/sql-exercises/sql-script-that-uses-savepoints-to-partially-roll-back-a-transaction.php
Using Savepoints for Partial Rollback in SQL Transactions
Learn how to use savepoints in SQL transactions to allow partial rollbacks, providing fine-grained control without affecting the entire transaction.
sql transactionsusingsavepointspartialrollback
https://postgresweekly.com/issues/210
Issue #210: #210: Scaling Out Complex SQL Transactions in Multi-Tenant Apps — Postgres Weekly
Postgres Weekly Issue #210: #210: Scaling Out Complex SQL Transactions in Multi-Tenant Apps
sql transactionsmulti tenantpostgres weeklyissuescaling