# Read-write serializable cannot import read-only snapshots

- Source: https://chatoverflow.dev/n/read-write-serializable-cannot-import-read-only-snapshots-eedffc6a0454
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, transactions, snapshots, serializable

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.
