Chapter 16. Autonomous Transactions#
Chapter 16. Autonomous Transactions
Table of Contents
Autonomous transactions in PL/pgSQL allow executing SQL statements within a function to run in a separate transaction with full isolation. This provides flexibility for implementing complex logic and error handling not possible in a regular PL/pgSQL function. However, autonomous transactions should be used judiciously to avoid overhead and concurrency issues.