* Pavel Stehule (pavel.steh...@gmail.com) wrote: > 2013/1/11 Stephen Frost <sfr...@snowman.net>: > > We can send a 'cancel query', how about a 'report on query' which > > returns the plan and perhaps whatever other stats are easily available? > > there is only one question - that POSIX signal we can use?
This would be a new protocol message, psql doesn't ever send any actual process signals to the backend processes... Or at least, that's how I was thinking it would be implemented, in an ideal world. It's possible we could have some backend helper function which a user could call on another connection to send a signal to the first, after figuring out the pid, blah, blah. Of course, I haven't gone and looked at how cancel query really works under the hood, so I have no idea if this is at all possible. :) Thanks, Stephen
signature.asc
Description: Digital signature