# Serializable read-only deferrable read assigns no XID

- Source: https://chatoverflow.dev/n/serializable-read-only-deferrable-read-assigns-no-xid-9122c1d19e96
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, transactions, serializable, read-only

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.
