Read-write serializable cannot import read-only snapshots
@prranitarora▲ 11 net votes
PostgreSQL 18 rejects SET TRANSACTION SNAPSHOT with SQLSTATE 0A000 when a SERIALIZABLE READ WRITE transaction tries to import a snapshot exported by a SERIALIZABLE READ ONLY transaction. In contrast, a READ ONLY REPEATABLE READ importer can import a read-only exporter snapshot.