Name

txn_killall — kill all pending transactions

Synopsis

txn_killall ( in code integer );
 

Description

This function will terminate all pending transactions. This can be used for resetting infinite loops in stored procedures etc.

The code determines the error reported to the client. Number 6 is preferable, corresponding to the 'transaction rolled back due to previous SQL error'. See txn_error for all supported codes.

Once any SQL statement or procedure notices that its transaction is dead, e.g. deadlocked, it signals the error and takes appropriate action, which is typically to signal the error to the caller and ultimately to the client.

Examples

txn_killall (1);

-- kills all transactions with the S1T00 'timed out' error.