Postgres Pro
Downloads
Home   >   mailing lists

Change pg_cancel_*() to ignore current backend - Mailing list pgsql-hackers

From Jim Nasby
Subject Change pg_cancel_*() to ignore current backend
Date
Msg-id 555BC043.60609@BlueTreble.com
Whole thread Raw
Responses Re: Change pg_cancel_*() to ignore current backend  (Marko Tiikkaja <marko@joh.to>)
Re: Change pg_cancel_*() to ignore current backend  (Eric Ridge <e_ridge@tcdi.com>)
List pgsql-hackers
Tree view 
I find it annoying to have to specifically exclude pg_backend_pid() from 
pg_stat_activity if I'm trying to kill a bunch of backends at once, and 
I can't think of any reason why you'd ever want to call a pg_cancel_* 
function with your own PID.

Any objections to modifying those functions so they do nothing when 
handed the PID of the current backend?
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Problems with question marks in operators (JDBC, ECPG, ...)
Next
From: Andrew Dunstan
Date:
Subject: Re: Bug in jsonb minus operator