Postgres Plus Advanced Server Oracle Compatibility Developer's Guide :
ROLLBACK TO SAVEPOINT -- roll back to a savepoint
ROLLBACK [ WORK ] TO [ SAVEPOINT ] savepoint_name
Roll back all commands that were executed after the savepoint was established. The savepoint remains valid and can be rolled back to again later, if needed.
ROLLBACK TO SAVEPOINT implicitly destroys all savepoints that were established after the named savepoint.
The savepoint to which to roll back.
Specifying a savepoint name that has not been established is an error.
ROLLBACK TO SAVEPOINT is not supported within SPL programs.
To undo the effects of the commands executed savepoint depts was established:
\set AUTOCOMMIT off INSERT INTO dept VALUES (50, 'HR', 'NEW YORK'); SAVEPOINT depts; INSERT INTO emp (empno, ename, deptno) VALUES (9001, 'JONES', 50); INSERT INTO emp (empno, ename, deptno) VALUES (9002, 'ALICE', 50); ROLLBACK TO SAVEPOINT depts;