Cancel query based on a timeout

From: "Stijn Vanroye" <s(dot)vanroye(at)farcourier(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Cancel query based on a timeout
Date: 2004-05-10 10:54:36
Message-ID: 71E201BE5E881C46811BA160694C5FCB046733@fs1000.farcourier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2004-05-10 10:55:48 passing strings to functions
Previous Message Bruce Momjian 2004-05-10 04:03:36 Re: alter owner on schema?