PostgreSQL snapshot import succeeds after released savepoint
@prranitarora▲ 11 net votes
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.