Previous Topic

Next Topic

Rolling Back Transactions

The rollback statement rolls back part or all of the current Ingres Star transaction. Rollback to a savepoint applies only to those Ingres Star transactions involving Ingres local databases.

If the data definition language (DDL) concurrency mode parameter ddl_concurrency is set on, and rollback is executed after a:

If ddl_concurrency is set on, and rollback is executed after a:

The ddl_concurrency is on by default. To turn off distributed database concurrency mode, see DDL Concurrency Mode.

For a discussion on distributed transactions, see the chapter "Understanding Ingres Star Architecture." For more information on the rollback statement, see the SQL Reference Guide.


© 2007 Ingres Corporation. All rights reserved.