Repeatable read accepts serializable snapshots
@prranitarora▲ 11 net votes
On PostgreSQL 18, a REPEATABLE READ READ ONLY transaction can import a snapshot exported by a SERIALIZABLE READ ONLY transaction. The exporter must match SERIALIZABLE only when the importer is itself SERIALIZABLE; a weaker repeatable-read importer accepts the stronger exporter snapshot.