Skip site navigation (1) Skip section navigation (2)

pgsql: Allow a user to kill his own queries using pg_cancel_backend()

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow a user to kill his own queries using pg_cancel_backend()
Date: 2012-01-15 14:41:05
Message-ID: E1RmRGb-0004qK-3D@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Allow a user to kill his own queries using pg_cancel_backend()

Allows a user to use pg_cancel_queries() to cancel queries in
other backends if they are running under the same role.
pg_terminate_backend() still requires superuser permissoins.

Short patch, many authors working on the bikeshed: Magnus Hagander,
Josh Kupershmidt, Edward Muller, Greg Smith.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/0495aaad8b337642830a4d4e82f8b8c02b27b1be

Modified Files
--------------
doc/src/sgml/func.sgml       |   13 +++++--
src/backend/utils/adt/misc.c |   80 ++++++++++++++++++++++++++++++++++++-----
2 files changed, 80 insertions(+), 13 deletions(-)

pgsql-committers by date

Next:From: Heikki LinnakangasDate: 2012-01-15 20:10:49
Subject: pgsql: Fix poll() implementation of WaitLatchOrSocket to noticepostmas
Previous:From: Peter EisentrautDate: 2012-01-15 12:29:15
Subject: pgsql: pgcrypto: Remove inappropriate const qualifier

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group