Re: Giving postgres roles 'sudo'-like access

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