On 12/19/2011 01:04 PM, Mario Splivalo wrote:
I need to have postgres role to be able to cancel queries run by that
same role.
This feature is close to commit as a new one for PostgreSQL 9.2:
http://archives.postgresql.org/message-id/4EEB3A2B.8090102@xxxxxxxxxxxxxxx
http://archives.postgresql.org/pgsql-hackers/2011-12/msg00822.php
You might use some of that code and make your own pg_cancel_backend-like
function that loads into the database.
--
Greg Smith 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
