Re: Plans for 8.2?

On Fri, Jan 13, 2006 at 03:40:48PM -0600, Jim C. Nasby wrote:
> It strikes me that if we had a way to abort a statement on another
> backend, you could abort anything that's been waiting more than x
> seconds for a lock via an external process watching pg_locks. Of course,
> that would be much more cumbersom than SET LOCK MODE TO WAIT n...

There's pg_cancel_backend(), but a mechanism like you describe seems
subject to race conditions: by the time you decide to cancel a query
and send the signal, the offending query might have completed and
you end up cancelling some subsequent query that just started.

--
Michael Fuhr