The COMMIT statement ends a transaction and saves the changes made by the SQL statements in the transaction to the database. The ROLLBACK statement also ends a transaction, but discards the ...

This statement rolls back an explicit or implicit transaction to the beginning of the transaction, or to a savepoint inside the transaction. You can use `ROLLBACK TRANSACTION` to erase all data ...

pg_statement_rollback is a PostgreSQL extension to add server side transaction with rollback at statement level like in Oracle or DB2. If at any time during execution a SQL statement causes an error, ...

If the LOCK TABLE statement is interrupted, the table may be locked on some partitions but not on others. If this occurs, either issue another LOCK TABLE statement to complete the locking on all ...

The ROLLBACK statement also ends a transaction, but discards the changes made by the SQL statements in the transaction and restores the database to its previous state.