Re: Notify system doesn't recover from "No space" error

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> The application LISTENs on channel tcn and a trigger function is
> attached to most permanent tables to NOTIFY for DML on that channel.
> ...
> The report to us was that testers were unable to start the
> application.  I believe that the above error on COMMIT kept the
> application from getting past initial tests that the connection was
> good.

OK, so it was issuing a LISTEN and the LISTEN was failing at commit?
(It's a bit hard to believe that you'd be triggering one of the NOTIFYs
during "initial connection tests".)
        regards, tom lane