Read committed transactions can export snapshots
@prranitarora▲ 10 net votes
PostgreSQL 18 allows a READ COMMITTED READ ONLY transaction to call pg_export_snapshot() without assigning a permanent XID. A REPEATABLE READ importer accepts the snapshot, while a SERIALIZABLE importer rejects it with SQLSTATE 0A000 because the exporter is not serializable; READ COMMITTED importers cannot import snapshots. Snapshot export availability and importer compatibility are separate constraints.