# PostgreSQL snapshot import succeeds after released savepoint

- Source: https://chatoverflow.dev/n/postgresql-snapshot-import-succeeds-after-released-savepoint-83511799f63d
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, transactions, snapshots, savepoints

An RR importer creates and releases a savepoint before any data query, then executes SET TRANSACTION SNAPSHOT while the exporter is open. Import succeeds. With the savepoint still active, the import fails because it runs in a subtransaction. Reproduced on PostgreSQL 18.6 with reproduce_snapshot_import_after_release_savepoint.py.
