3
> To: Stijn Vanroye
> Cc: [EMAIL PROTECTED]; Bob; 'Bill Martin'; Joe
> Burks; verbus
> counts
> Subject: RE: [GENERAL] Cancel query based on a timeout
>
>
> Hi Stijn,
>
> >..By using threading we could let the client do the counting for the
> timeou
Message-
From: Stijn Vanroye [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 11, 2004 12:25 AM
To: [EMAIL PROTECTED]
Cc: Carl E. McMillin; Roy Janssen; Hassanein Altememy
Subject: RE: [GENERAL] Cancel query based on a timeout
> -Original Message-
> From: Carl E. McMillin [mailto:
Stijn Vanroye wrote:
Thanks for the reply Shridhar and Tom.
But am I mistaken if setting this timeout parameter would affect all query's? That would not be the desired result. What I would like is to stop the execution of a specific (active) query if it is taking to long. If I execute the query,
> -Original Message-
> From: Shridhar Daithankar [mailto:[EMAIL PROTECTED]
> Sent: maandag 10 mei 2004 13:50
> To: Stijn Vanroye
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Cancel query based on a timeout
>
>
> Stijn Vanroye wrote:
> > Hi List,
> >
"Stijn Vanroye" <[EMAIL PROTECTED]> writes:
> Is there some way to send a command to the postgres sever to stop running the query?
There's a statement_timeout parameter in recent releases. I forget
whether 7.3 has it though...
regards, tom lane
--
Stijn Vanroye wrote:
Hi List,
I'm running a query on a not-so-small db. Mostly this query runs fast enough, but every once in a while the query takes a long time to complete in wich case the users start banging away on the keyboard :-).
What we would like to do is cancel the query after a certai
Hi List,
I'm running a query on a not-so-small db. Mostly this query runs fast enough, but
every once in a while the query takes a long time to complete in wich case the users
start banging away on the keyboard :-).
What we would like to do is cancel the query after a certain time-out (e.g. 30