Re: Change pg_cancel_*() to ignore current backend

On 5/19/15 6:30 PM, David G. Johnston wrote:
> On Tue, May 19, 2015 at 4:23 PM, Marko Tiikkaja <marko@joh.to
> <mailto:marko@joh.to>>wrote:
>
>     On 2015-05-20 00:59, Jim Nasby wrote:
>
>         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.
>
>
>     That's a rather easy way of testing that you're handling FATAL
>     errors correctly from a driver/whatever.
>
>
> I'm having trouble thinking of a PC name for the function we create that
> should do this; while changing the pg_cancel_* functions to operate more
> safely.

We could add a second parameter to the current functions: allow_own_pid 
DEFAULT false. To me that seems better than an entirely separate set of 
functions.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com