Thanks Daniele
-----Original Message-----
From: Daniele Varrazzo [mailto:daniele.varrazzo@xxxxxxxxx]
Sent: Wed 4/20/2011 1:15 AM
To: tamanna madaan
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: setting connection/ query timeout
On Tue, Apr 19, 2011 at 8:09 PM, tamanna madaan
<tamanna.madan@xxxxxxxxxxxxxxx> wrote:
> Sometimes this query gets stuck for unknown reason . So, for this particular
> query I want to set a timeout
> . I dont want to change "statement_timeout" in postgresql.conf as this would
> affect all the connections/queries.
> I just want to set timeout for above mentioned query . How can I do that ??
You can set a timeout only valid for the session using SET:
=> set statement_timeout to 1000;
SET
=> select pg_sleep(2);
ERROR: canceling statement due to statement timeout
-- Daniele
