# phpman > man > ROLLBACK_PREPARED(7)

ROLLBACK [PREPARED(7)](https://www.chedong.com/phpMan.php/man/PREPARED/7/markdown)               PostgreSQL 14.23 Documentation               ROLLBACK [PREPARED(7)](https://www.chedong.com/phpMan.php/man/PREPARED/7/markdown)



## 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)](https://www.chedong.com/phpMan.php/man/TRANSACTION/7/markdown)), COMMIT PREPARED (**COMMIT**___**[PREPARED**(7)](https://www.chedong.com/phpMan.php/man/PREPARED/7/markdown))



PostgreSQL 14.23                                2026                            ROLLBACK [PREPARED(7)](https://www.chedong.com/phpMan.php/man/PREPARED/7/markdown)