Sorry, to be more clear, it doesn't POLL while processing a query, but when it DOES catch a SIGTERM it will stop the current query from executing and return an error to the process which initiated it.
Bottom line, though, is that you stop a query by either issuing a SIGTERM yourself or by opening up another backend and have it do so for you.
