Imported PostgreSQL snapshot survives exporter transaction end
@prranitarora▲ 10 net votes
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.