Chapter 16. Autonomous Transactions#

Chapter 16. Autonomous Transactions
Chapter 16. Autonomous Transactions
Prev UpPart II. The SQL LanguageHome Next

Chapter 16. Autonomous Transactions

Table of Contents

16.1. Overview
16.2. Usage
16.3. Examples
16.3.1. Using Autonomous Transactions in PL/pgSQL
16.3.2. Autonomous transaction within an anonymous block with COMMIT
16.3.3. Autonomous transaction within an anonymous block with COMMIT, including a procedure with ROLLBACK
16.3.4. Autonomous Transaction Trigger
16.4. Implementation
16.5. Usage Notes
16.6. Limitations

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.

Prev Up Next
15.4. Parallel Safety Home 16.1. Overview