Re: Cancel a query.

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cancel a query.
Date: 2010-11-22 14:51:03
Message-ID: AANLkTikLd1sqgu1tju68qwzuYfpSBiw5-oPxZ-Zqbnym@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Nov 20, 2010 at 12:41 AM, Rob Brown-Bayliss
<r(dot)brown(dot)bayliss(at)gmail(dot)com> wrote:
> I am trying to catch time outs etc, basically after a set amount of
> time I am assuming something has failed.

Just set a statement timeout before running your potentially long
queries. Your client code will return an error which you can then
detect and react to properly.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Turner, John J 2010-11-22 16:31:59 extensions: creation of .sql files
Previous Message Matthieu Huin 2010-11-22 14:10:24 Re: Cancel a query.