ROLLBACK - abort the current transaction

       The command ROLLBACK conforms to the SQL standard. The form ROLLBACK TRANSACTION is a PostgreSQL
       extension.

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

       To abort all changes:

           ROLLBACK;

       ROLLBACK - abort the current transaction

       Use COMMIT to successfully terminate a transaction.

       Issuing ROLLBACK outside of a transaction block emits a warning and otherwise has no effect.  ROLLBACKANDCHAIN outside of a transaction block is an error.

       WORK
       TRANSACTION
           Optional key words. They have no effect.

       AND CHAIN
           If AND CHAIN is specified, a new (not aborted) transaction is immediately started with the same
           transaction characteristics (see SET TRANSACTION (SET_TRANSACTION(7))) as the just finished one.
           Otherwise, no new transaction is started.

BEGIN(7), COMMIT(7), ROLLBACK TO SAVEPOINT (ROLLBACK_TO_SAVEPOINT(7))

PostgreSQL 17.5                                       2025                                           ROLLBACK(7)

       ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]