Re: [SQL] Query kill

2002-07-12 Thread Bruce Momjian
I assumed from the user's question that the admin just wanted to stop a specific query of a specific backend. Sending a SIGINT to the backend will do that. I wasn't talking client request or anything like that. Look at the description of the question below. ---

Re: [SQL] Query kill

2002-07-12 Thread Jan Wieck
Bruce Momjian wrote: > > Jan Wieck wrote: > > Bruce Momjian wrote: > > > > > > Rudi Starcevic wrote: > > > > Hello, > > > > > > > > If I write a query that is inefficient or in an eternal loop how > > > > do I stop it without restarting the postmaster ? > > > > > > > > I can see many postmaster p

Re: [SQL] Query kill

2002-07-12 Thread Bruce Momjian
Jan Wieck wrote: > Bruce Momjian wrote: > > > > Rudi Starcevic wrote: > > > Hello, > > > > > > If I write a query that is inefficient or in an eternal loop how > > > do I stop it without restarting the postmaster ? > > > > > > I can see many postmaster processed appearing in the output of the 'ps

Re: [SQL] Query kill

2002-07-12 Thread Jan Wieck
Bruce Momjian wrote: > > Rudi Starcevic wrote: > > Hello, > > > > If I write a query that is inefficient or in an eternal loop how > > do I stop it without restarting the postmaster ? > > > > I can see many postmaster processed appearing in the output of the 'ps' > > command. > > Do I need to sto

Re: [SQL] Query kill

2002-07-12 Thread eric soroos
On Fri, 12 Jul 2002 01:01:31 -0400 (EDT) in message <[EMAIL PROTECTED]>, Bruce Momjian <[EMAIL PROTECTED]> wrote: > Rudi Starcevic wrote: > > Hello, > > > > If I write a query that is inefficient or in an eternal loop how > > do I stop it without restarting the postmaster ? > > > > I can see m

Re: [SQL] Query kill

2002-07-11 Thread Bruce Momjian
Rudi Starcevic wrote: > Hello, > > If I write a query that is inefficient or in an eternal loop how > do I stop it without restarting the postmaster ? > > I can see many postmaster processed appearing in the output of the 'ps' > command. > Do I need to stop/kill them all or can I stop just the