rollback(7) [freebsd man page]

ROLLBACK(7)							   SQL Commands 						       ROLLBACK(7)

NAME

       ROLLBACK - abort the current transaction

SYNOPSIS

       ROLLBACK [ WORK | TRANSACTION ]

DESCRIPTION

       ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.

PARAMETERS

       WORK

       TRANSACTION
	      Optional key words. They have no effect.

NOTES

       Use COMMIT [commit(7)] to successfully terminate a transaction.

       Issuing ROLLBACK when not inside a transaction does no harm, but it will provoke a warning message.

EXAMPLES

       To abort all changes:

       ROLLBACK;

COMPATIBILITY

       The SQL standard only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise, this command is fully conforming.

SEE ALSO

       BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)]

SQL - Language Statements					    2010-05-14							       ROLLBACK(7)

ROLLBACK 
PREPARED(7)					  PostgreSQL 9.2.7 Documentation				      ROLLBACK PREPARED(7)

NAME

       ROLLBACK_PREPARED - cancel a transaction that was earlier prepared for two-phase commit

SYNOPSIS

       ROLLBACK PREPARED transaction_id

DESCRIPTION

       ROLLBACK PREPARED rolls back a transaction that is in prepared state.

PARAMETERS

       transaction_id
	   The transaction identifier of the transaction that is to be rolled back.

NOTES

       To roll back a prepared transaction, you must be either the same user that executed the transaction originally, or a superuser. But you do
       not have to be in the same session that executed the transaction.

       This command cannot be executed inside a transaction block. The prepared transaction is rolled back immediately.

       All currently available prepared transactions are listed in the pg_prepared_xacts system view.

EXAMPLES

       Roll back the transaction identified by the transaction identifier foobar:

	   ROLLBACK PREPARED 'foobar';

COMPATIBILITY

       ROLLBACK PREPARED is a PostgreSQL extension. It is intended for use by external transaction management systems, some of which are covered
       by standards (such as X/Open XA), but the SQL side of those systems is not standardized.

SEE ALSO

       PREPARE TRANSACTION (PREPARE_TRANSACTION(7)), COMMIT PREPARED (COMMIT_PREPARED(7))

PostgreSQL 9.2.7						    2014-02-17						      ROLLBACK PREPARED(7)