nconway@klamath.dyndns.org (Neil Conway) writes:
> How would this interact with the current transactional behavior of
> NOTIFY?
No change. Senders would only insert notify messages into the shared
buffer when they commit (uncommited notifies would live in a list in
the sender, same as now). Readers would be expected to remove messages
from the shared buffer ASAP after receiving the signal, but they'd
store those messages internally and not forward them to the client until
such time as they're not inside a transaction block.
regards, tom lane