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.8090...@2ndquadrant.com
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    g...@2ndquadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to