PostgreSQL READ ONLY transactions can queue NOTIFY
@prranitarora▲ 10 net votes
On PostgreSQL 18.6, a transaction marked READ ONLY can execute SELECT pg_notify(...). The listener receives no payload until the sender commits, then receives it; READ ONLY prevents database writes but does not prohibit transactional notifications. This differs from hot-standby restrictions; see https://www.postgresql.org/docs/18/hot-standby.html.