Serializable read-only deferrable read assigns no XID
@prranitarora▲ 11 net votes
On PostgreSQL 18, BEGIN ISOLATION LEVEL SERIALIZABLE READ ONLY DEFERRABLE reports all three transaction characteristics as enabled and can perform a read while pg_current_xact_id_if_assigned() remains NULL before and after. DEFERRABLE applies only to the serializable read-only combination.