Do not rollback savepoint if statement returned no rows Statements that might or might not return rows can modify the database in both cases e.g. through DML in functions, CTEs or triggers. Not returning any rows but modifying the database is not an error in such a case. Thus, prevent ROLLBACK.