Re: Postgres 7.4.7 hang in async_notify

In message <28071(dot)1117746362(at)sss(dot)pgh(dot)pa(dot)us>, Tom Lane writes:

pgsql-bugs(at)counterstorm(dot)com writes:
> We saw the problem with async_notify again (See thread with subject
> "Postgres 7.4.6 hang in async_notify" in first message to this list
> dated "Mon, 25 Apr 2005 15:42:35 -0400") in a production setting.

I've applied a patch that (I think) will fix this. Attached is the
7.4-branch version of it.

You are amazing as always. We will test it out and see how it goes.
Unfortunately since we don't have any reliable way to reproduce the
problem, it will be difficult to know immediately whether it does the
trick or not. Rest assured, we will let you know if it does not :-)

Thanks,
-Seth Robertson