Tom Lane wrote: > "Magnus Hagander" <[EMAIL PROTECTED]> writes: > >> If we are going to allow session kill then of course we need > >> PID for that. > > > I still say we need this. > > Well, that seems to be the consensus, so I won't stand in the way. > > If you like the cancel-by-XID idea then I'd suggest providing two > functions: pg_cancel_query(XID) to send SIGINT and pg_kill_session(PID) > to send SIGTERM. I'm not sure if the other two combinations (SIGINT by > PID and SIGTERM by XID) are worth providing.
Agreed. Two functions, cancel by xid (skips cancel if xid changes during command), and kill by pid for remote admin apps, is great. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
