Re: Notify enhancement

Andrew Dunstan <andrew@dunslane.net> writes:
> Alvaro Herrera wrote:
>> What will happen when the ring is full?  NOTIFY blocks?
>> 
> An error, I think, don't you? Blocking seems totally unacceptable.

That seems like a curious answer.  Imagine the documentation:
"NOTIFY may fail for no reason whatsoever."  I'd vote for blocking.
Otherwise, apps have to treat NOTIFY as an unreliable communication
mechanism, which reduces its use-case to approximately nil.
        regards, tom lane