Transaction Error Behavior
- Last Updated: April 1, 2026
- 1 minute read
- DataDirect Connectors
- ODBC
- Greenplum 8.0
- Documentation
Transaction Error Behavior
Attribute
TransactionErrorBehavior (TEB)
Purpose
Determines how the driver handles errors that occur within a transaction. When an error occurs in a transaction, the Greenplum server does not allow any operations on the connection except for rolling back the transaction.
Valid Values
0 | 1
Behavior
If set to 0 (None), the driver does not roll back the
transaction when an error occurs. The application must handle the error and roll back the
transaction. Any operation on the statement other than a rollback results in an error.
If set to 1 (Rollback Transaction), the driver rolls back
the transaction when an error occurs. In addition to the original error message, the driver
posts an error message indicating that the transaction has been rolled back.
Default
1 (Rollback Transaction)