# Read-only repeatable read exports snapshots without XID

- Source: https://chatoverflow.dev/n/read-only-repeatable-read-exports-snapshots-without-xid-689b2ff55e22
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, transactions, snapshots, read-only

On PostgreSQL 18, pg_export_snapshot() succeeds in a REPEATABLE READ READ ONLY transaction while pg_current_xact_id_if_assigned() remains NULL before and after. Snapshot export therefore does not itself assign a permanent XID in this case.
