Re: [GENERAL] Cancel query based on a timeout

2004-05-13 Thread Stijn Vanroye
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

Re: [GENERAL] Cancel query based on a timeout

2004-05-11 Thread Carl E. McMillin
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:

Re: [GENERAL] Cancel query based on a timeout

2004-05-10 Thread Shridhar Daithankar
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,

Re: [GENERAL] Cancel query based on a timeout

2004-05-10 Thread Stijn Vanroye
> -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, > >

Re: [GENERAL] Cancel query based on a timeout

2004-05-10 Thread Tom Lane
"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 --

Re: [GENERAL] Cancel query based on a timeout

2004-05-10 Thread Shridhar Daithankar
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

[GENERAL] Cancel query based on a timeout

2004-05-10 Thread Stijn Vanroye
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

Re: [GENERAL] cancel query

2003-12-11 Thread H A Prahalad
Thanks. I have access to the Statement object that issued the original query. I used the latest JDBC driver for PostgreSQl7.3 and JDK1.4 and I used threads to achieve it. Thanks once again. prahalad On Thu, 11 Dec 2003, Kris Jurka wrote: > > > On Tue, 9 Dec 2003, H A Prahalad wrote: > > > > >

Re: [GENERAL] cancel query

2003-12-11 Thread Kris Jurka
On Tue, 9 Dec 2003, H A Prahalad wrote: > > Hello, > I want to know whether PostgreSQL support cancel() [cancel > JDBCStatement]. I want to abort a long running query issued/executed by a > java application using JDBC driver to connect to the database. Thanks. > The JDBC driver does suppo

[GENERAL] cancel query

2003-12-09 Thread H A Prahalad
Hello, I want to know whether PostgreSQL support cancel() [cancel JDBCStatement]. I want to abort a long running query issued/executed by a java application using JDBC driver to connect to the database. Thanks. -Prahalad ---(end of broadcast)-