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
AFAIK, there is a statement timeout option but exactly which version brought it in escapes me ATM...Most probably 7.4.x but don't take my word for it. Check you r postgrersql.conf for details.
HTH
Shridhar
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
