Attach tasks/pgsqls to http_requests once more.

This way if an http request is removed while tasks or
pgsqls are still active they are free'd out and cancelled
properly.