Postgres Pro
Downloads
Home   >   mailing lists

Re: Set timeout just on a query? - Mailing list pgsql-general

From Bharath Rupireddy
Subject Re: Set timeout just on a query?
Date
Msg-id CALj2ACXH+=1T3QKtwhc9S2_CDR+ndVUE8fph8Xo1puRp+vf-vg@mail.gmail.com
Whole thread Raw
In response to Set timeout just on a query?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-general
Tree view 
On Tue, May 10, 2022 at 6:29 AM Shaozhong SHI <shishaozhong@gmail.com> wrote:
>
>
> Can timeout be set just on a query?
>
> Can we do the following?
>
> Begin
>
> do a query
> set timeout
> Exception
> report a record
>
> End;

Won't the statement_timeout [1] help here?

[1] https://www.postgresql.org/docs/devel/runtime-config-client.html

Regards,
Bharath Rupireddy.

pgsql-general by date:

Previous
From: Shaozhong SHI
Date:
Subject: Set timeout just on a query?
Next
From: 正华吕
Date:
Subject: Question on cast string to date