Patrick,
> How can I cancel a long running query besides quitting the app?
> TIA
Methods:
1) Shutdown and restart the database server with pg_ctl -m fast restart.
2) Kill the client connection proccess on the server side. This is dangerous
if the long-running query is a data-modification query.
--
-Josh Berkus
Aglio Database Solutions
San Francisco