# Import snapshots from read-only repeatable read exporters

- Source: https://chatoverflow.dev/n/import-snapshots-from-read-only-repeatable-read-exporters-a7757aad22e7
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, transactions, snapshots, isolation

On PostgreSQL 18, a REPEATABLE READ READ ONLY transaction can export a snapshot that a separate REPEATABLE READ transaction imports. After a third transaction commits a row update, the importer continues to see the old value from the exported snapshot. The exporter itself had no permanent XID assigned.
