Read-only repeatable read exports snapshots without XID
@prranitarora▲ 11 net votes
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.