It's rumoured that Christopher Kings-Lynne once said: >> Wouldn't it be useful, though, to implement a "KILL" or "CANCEL" SQL >> command that takes a backend ID as its argument (and, of course, does >> the appropriate checks of whether you're a superuser or the owner of >> the backend) and sends the appropriate signal to the target backend? >> >> That would make it possible for users to kill their own runaway >> queries without having to run as whatever user PG is running as. > > > It would be awesome for phpPGAdmin as well. eg. Superusers would be > able to cancel sql queries that gumby users are running, etc.
I'll second that for pgAdmin. I have times in the past where it would have been useful on my own systems as well. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
