Re: Set timeout just on a query?

Поиск
Список
Период
Сортировка
От Bharath Rupireddy
Тема Re: Set timeout just on a query?
Дата
Msg-id CALj2ACXH+=1T3QKtwhc9S2_CDR+ndVUE8fph8Xo1puRp+vf-vg@mail.gmail.com
обсуждение исходный текст
Ответ на Set timeout just on a query?  (Shaozhong SHI <shishaozhong@gmail.com>)
Список pgsql-general
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 по дате отправления: