Product Documentation

Appearance

ROLLBACK ​

Roll back the current transaction, discarding any changes that the transaction would have committed.

ROLLBACK [ WORK | TRANSACTION ]

For example, the season table is not dropped because the ROLLBACK command ends the transaction:

premdb=# begin;
BEGIN
premdb=# drop table season;
DROP TABLE
premdb=# rollback;
ROLLBACK
premdb=# \d season
             Table "public.season"
   Column    |         Type          | Modifiers 
-------------+-----------------------+-----------
 seasonid    | smallint              | 
 season_name | character(9)          | 
 numteams    | smallint              | 
 winners     | character varying(30) | 

Distribution: Replicated

If no transaction is in progress, the ROLLBACK command returns a warning and has no other effect:

premdb=# rollback;
WARNING:  there is no transaction in progress
ROLLBACK

Parent topic:SQL Commands