Patch applied. Thanks. Not sure where to document them. I think we talked about this already.
I updated the system catalog version. --------------------------------------------------------------------------- Magnus Hagander wrote: > Arrgh, when will I ever learn :-( > > Attached. > > //Magnus > > > >-----Original Message----- > >From: Bruce Momjian [mailto:[EMAIL PROTECTED] > >Sent: den 26 maj 2004 20:50 > >To: Magnus Hagander > >Cc: Neil Conway; [EMAIL PROTECTED] > >Subject: Re: [PATCHES] Cancel/Kill backend functions > > > > > > > >Magnus, would you please resumbit this as a context diff? > > > >--------------------------------------------------------------- > >------------ > > > >Magnus Hagander wrote: > >> Okay, here is an updated patch. now uses IsBackendPid(), which is > >> closely modeled (read cut-and-pasted) from > >> TransactionIdIsInProgress(). > >> > >> Since it's no longer a pgstat function, I moved it to "misc.c". Not > >> 100% that's the right place either, but it seemed like the best > >> alternative. > >> > >> //Magnus > >> > >> > >> >-----Original Message----- > >> >From: Neil Conway [mailto:[EMAIL PROTECTED] > >> >Sent: den 22 maj 2004 10:00 > >> >To: Magnus Hagander > >> >Cc: [EMAIL PROTECTED] > >> >Subject: Re: [PATCHES] Cancel/Kill backend functions > >> > > >> > > >> >Magnus Hagander wrote: > >> >> Per previous discussions, here are two functions to send INT and > >> >> TERM signals to other backends.They permit only INT and TERM, and > >> >> permits sending only to postgresql backends (as registered in > >> >> pgstat). > >> > > >> >Why does this depend on pgstat? ISTM it would be better to use the > >> >per-backend PGPROC information, which is stored in shared memory. > >> >Consider TransactionIdIsInProgress() for an example. > >> > > >> >-Neil > >> > > > > >Content-Description: termbackend.patch > > > >[ Attachment, skipping... ] > > > >> > >> ---------------------------(end of > >> broadcast)--------------------------- > >> TIP 7: don't forget to increase your free space map settings > > > >-- > > 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 > > Content-Description: termbackend2.patch [ Attachment, skipping... ] -- 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 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match