Postgres Pro
Downloads
Home   >   mailing lists

Thread: Set timeout just on a query?

Set timeout just on a query?

From
Shaozhong SHI
Date:

Can timeout be set just on a query?

Can we do the following?

Begin

do a query
set timeout 
Exception
report a record

End;

Regards,
David

Re: Set timeout just on a query?

From
Bharath Rupireddy
Date:
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.