| From: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> |
|---|---|
| To: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Set timeout just on a query? |
| Date: | 2022-05-10 03:56:47 |
| Message-ID: | CALj2ACXH+=1T3QKtwhc9S2_CDR+ndVUE8fph8Xo1puRp+vf-vg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Tue, May 10, 2022 at 6:29 AM Shaozhong SHI <shishaozhong(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 正华吕 | 2022-05-10 04:28:35 | Question on cast string to date |
| Previous Message | Christophe Pettus | 2022-05-10 01:00:08 | Re: Set timeout just on a query? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kimaidou | 2022-05-23 11:55:07 | Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ? |
| Previous Message | Christophe Pettus | 2022-05-10 01:00:08 | Re: Set timeout just on a query? |