Re: Another notify question

Jeff Davis <list-pgsql-general@dynworks.com> writes:
> The discussion about implementation has lead me to the following question:
> What should I be sure that notify will do? Tom seems to think that delivery
> of a notification should not be guarenteed (if I understand what he is
> saying), which is fine with me.

Well, I definitely wasn't advocating that.  IMHO you should be
guaranteed the delivery of *some* notification, but possibly one
containing less information than what was sent.  Or you might get
a notification when in fact none was sent.  This should be okay
for ordinary uses of NOTIFY, as long as such cases are infrequent
(so that you don't waste many cycles checking for events that
didn't happen).

            regards, tom lane