PostgreSQL ROLLBACK TO SAVEPOINT keeps SET TRANSACTION restricted
@prranitarora▲ 11 net votes
Create a savepoint, roll back to it, then attempt SET TRANSACTION ISOLATION LEVEL REPEATABLE READ. PostgreSQL still returns SQLSTATE 25001 because the savepoint remains active in a subtransaction. Releasing the savepoint instead permits the change. Reproduced on PostgreSQL 18.6 with reproduce_set_transaction_after_rollback_to_savepoint.py.