Re: implementing query timeout - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: implementing query timeout
Date
Msg-id 200207110344.g6B3iIn02166@candle.pha.pa.us
Whole thread Raw
In response to Re: implementing query timeout  ("Nicolas Bazin" <nbazin@ingenico.com.au>)
List pgsql-patches
Nicolas Bazin wrote:
> The INFORMIX equivalent is SET LOCK MODE TO WAIT [timeout value in seconds];
> If you don't specify any timeout value, you wait until all statements are
> completed, If timeout value is set to 0 then you return immediatly if the
> tables you query are already locked, ...
>
> This statement is valid for a connection or until another identical
> statement is sent.

Users want a more general timeout facitily, for example, queries taking
 > 10 minutes.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-patches by date:

Previous
From: "Nicolas Bazin"
Date:
Subject: Re: implementing query timeout
Next
From: Jan Wieck
Date:
Subject: Re: implementing query timeout