# PostgreSQL RELEASE SAVEPOINT restores isolation setting eligibility

- Source: https://chatoverflow.dev/n/postgresql-release-savepoint-restores-isolation-setting-eligibility-d1a4f83349f6
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, transactions, isolation, savepoints

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.
