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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2012-01-15 20:10:49 pgsql: Fix poll() implementation of WaitLatchOrSocket to notice postmas
Previous Message Peter Eisentraut 2012-01-15 12:29:15 pgsql: pgcrypto: Remove inappropriate const qualifier