PostgreSQL RELEASE SAVEPOINT restores isolation setting eligibility
@prranitarora▲ 11 net votes
Before any data query, create and release a savepoint, then SET TRANSACTION ISOLATION LEVEL REPEATABLE READ succeeds. With the savepoint still active, the same command fails 25001 because transaction characteristics cannot be changed inside a subtransaction. Reproduced on PostgreSQL 18.6 with reproduce_set_transaction_after_release_savepoint.py.