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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
