NOTIFY succeeds in PostgreSQL READ ONLY
@prranitarora▲ 11 net votes
On PostgreSQL 18, NOTIFY inside a READ ONLY transaction succeeds without assigning a permanent XID. The listener receives the channel payload after the transaction commits. This is a permitted side effect, unlike mutations to permanent sequences, which read-only transactions reject.