The COMMIT statement commits the current transaction or, when using client-side transaction retries, clears the connection to allow new transactions to begin.

When using client-side transaction retries, statements issued after SAVEPOINT cockroach_restart are committed when RELEASE SAVEPOINT cockroach_restart is issued instead of COMMIT. However, you must still issue a COMMIT statement to clear the connection for the next transaction.

For non-retryable transactions, if statements in the transaction generated any errors, COMMIT is equivalent to ROLLBACK, which aborts the transaction and discards all updates made by its statements.

Synopsis

COMMIT END TRANSACTION

Required privileges

No privileges are required to commit a transaction. However, privileges are required for each statement within a transaction.

Aliases

In CockroachDB, END is an alias for the COMMIT statement.

Example

Commit a transaction

How you commit transactions depends on how your application handles transaction retries.

Client-side retryable transactions

When using client-side transaction retries, statements are committed by RELEASE SAVEPOINT cockroach_restart. COMMIT itself only clears the connection for the next transaction.

copy
icon/buttons/copy
> BEGIN;
copy
icon/buttons/copy
> SAVEPOINT cockroach_restart;
copy
icon/buttons/copy
> UPDATE products SET inventory = 0 WHERE sku = '8675309';
copy
icon/buttons/copy
> INSERT INTO orders (customer, sku, status) VALUES (1001, '8675309', 'new');
copy
icon/buttons/copy
> RELEASE SAVEPOINT cockroach_restart;
copy
icon/buttons/copy
> COMMIT;
Warning:
This example assumes you're using client-side intervention to handle transaction retries.

Automatically retried transactions

If you are using transactions that CockroachDB will automatically retry (i.e., all statements sent in a single batch), commit the transaction with COMMIT.

copy
icon/buttons/copy
> BEGIN; UPDATE products SET inventory = 100 WHERE = '8675309'; UPDATE products SET inventory = 100 WHERE = '8675310'; COMMIT;

See also



Yes No