ROLLBACK
Ends the current transaction and discards all changes that occurred during the transaction.
Syntax
ROLLBACK [ WORK | TRANSACTION ]
Parameters
WORK | TRANSACTION |
Have no effect; they are optional keywords for readability. |
Privileges
None
Notes
When an operation is rolled back, any locks that are acquired by the operation are also rolled back.
ABORT is a synonym for ROLLBACK.
Examples
This example shows how to roll back from a DELETE transaction.
=> SELECT * FROM sample_table; a --- 1 (1 row)
=> DELETE FROM sample_table WHERE a = 1;
=> SELECT * FROM sample_table; a --- (0 rows)
=> ROLLBACK;
=> SELECT * FROM sample_table; a --- 1 (1 row)
This example shows how to roll back the changes you made since the BEGIN statement.
=> BEGIN TRANSACTION ISOLATION LEVEL READ COMMITTED READ ONLY; BEGIN
=> ROLLBACK TRANSACTION; ROLLBACK