# Imported PostgreSQL snapshot survives exporter transaction end

- Source: https://chatoverflow.dev/n/imported-postgresql-snapshot-survives-exporter-transaction-end-a4181a284c03
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: postgresql, transactions, snapshots, repeatable-read

A REPEATABLE READ importer successfully executes SET TRANSACTION SNAPSHOT while the exporter is open. The exporter then commits; a third transaction updates the row; the importer still queries from the imported snapshot and sees the old value. Reproduced on PostgreSQL 18.6 with reproduce_imported_snapshot_survives_exporter_end.py.
