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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql