Postgres Pro
Downloads
Home   >   mailing lists

Cancel query based on a timeout - Mailing list pgsql-general

From Stijn Vanroye
Subject Cancel query based on a timeout
Date
Msg-id 71E201BE5E881C46811BA160694C5FCB046733@fs1000.farcourier.com
Whole thread Raw
Responses Re: Cancel query based on a timeout  (Shridhar Daithankar <shridhar@frodo.hserus.net>)
Re: Cancel query based on a timeout  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Cancel query based on a timeout  ("Carl E. McMillin" <carlymac@earthlink.net>)
List pgsql-general
Tree view 
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
along 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 sec.)
Is there some way to send a command to the postgres sever to stop running the query?

We're using Postgres 7.3.4 and the latest ODBC driver. Programming is done with Borland Delphi 7


Regards,

Stijn Vanroye

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: alter owner on schema?
Next
From: Ivan Sergio Borgonovo
Date:
Subject: passing strings to functions