You could create a function calling that query with "Security Definer"
(the function will be called with the privileges of the user that
created the function) :
CREATE OR REPLACE FUNCTION stop_query(myprocpid int)
RETURNS BOOLEAN AS $$
DECLARE
b boolean;
BEGIN
SELECT pg_cancel_backend(myprocpid) INTO b;
RETURN b;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;
Make sure this function is created with the super user. You can then
call it with any user.
Hope this helps.
Matthieu
Le 20/11/2010 06:41, Rob Brown-Bayliss a écrit :
Hi
I have some code using psycopg in python. Connecting in async mode.
I am trying to catch time outs etc, basically after a set amount of
time I am assuming something has failed.
I then want to use "select pg_cancel_backend(15209);" to cancel the
query. But I can't unless I am connected as the postgres super user.
How can I get my app to cancel one of it's own queries while logged on
as a normal user?
Thanks.
--
Rob
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
