openGauss autonomous-transaction

Autonomous Transaction

Availability

This feature is available since openGauss 1.1.0.

Introduction

An autonomous transaction is a type of transaction in which the commit of a sub-transaction is not affected by the commit or rollback of the main transaction.

Benefits

This feature meets diversified application scenarios.

Description

In an autonomous transaction, a specified type of SQL statements are executed in an independent transaction context during the execution of the main transaction. The commit and rollback operations of an autonomous transaction are not affected by the commit and rollback operations of the main transaction.

User-defined functions and stored procedures support autonomous transactions.

A typical application scenario is as follows: A table is used to record the operation information during the main transaction execution. When the main transaction fails to be rolled back, the operation information recorded in the table cannot be rolled back.

Enhancements

None.

Constraints

• A trigger function does not support autonomous transactions.
• In the autonomous transaction block of a function or stored procedure, static SQL statements do not support variable transfer.
• Autonomous transactions do not support nesting.
• A function containing an autonomous transaction does not support the return value of parameter transfer.
• A stored procedure or function that contains an autonomous transaction does not support exception handling.

Dependencies

None.
开源社区地址： https://gitee.com/opengauss/openGauss-migration-portal/tree/master
详细参考文档：README.md 、 命令行参数名称及说明.md
详情查看：https://opengauss.org
详情查看：https://docs-opengauss.osinfra.cn

openGauss