On Jan 4, 2011, at 17:29, Bryce Nesbitt wrote:
> Should I expect pg_cancel_backend() to work in a case like this? If not does this sound like a reportable bug?
pg_cancel_backend() cancels the running query for that backend. In the case of <IDLE>, there is no running query for that backend.
Likely you're looking for pg_terminate_backend().
Michael Glaesemann
grzm seespotcode net