Tom Lane wrote:
> Allowing SIGPIPE to kill the backend is completely infeasible, as the
> backend would be unable to release locks etc before dying.
So the upshot is really not that ignoring SIGPIPE is specifically
intended as the optimal solution but that writing a proper cleanup
handler for SIGPIPE seems very difficult.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/