MIME-Version: 1.0
References: 
 <CA+i5JwYsXzYwBT87y2jtch=Lg1s=d+XgJ0sJS0TV8VQT8g_Xtg@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwYsXzYwBT87y2jtch=Lg1s=d+XgJ0sJS0TV8VQT8g_Xtg@mail.gmail.com>
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Tue, 10 May 2022 01:59:05 +0100
Message-ID: 
 <CA+i5Jwbc2B=CT1JxVc7Tke5JFRpBfhyzLA__tdr6t1GckVCwQg@mail.gmail.com>
Subject: Set timeout just on a query?
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007e7fbb05de9dd577"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5Jwbc2B%3DCT1JxVc7Tke5JFRpBfhyzLA__tdr6t1GckVCwQg%40mail.gmail.com>
Precedence: bulk

--0000000000007e7fbb05de9dd577
Content-Type: text/plain; charset="UTF-8"

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

--0000000000007e7fbb05de9dd577
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_quote"><br><div dir=3D"ltr">Can timeou=
t be set just on a query?<div><br></div><div>Can we do the following?</div>=
<div><br></div><div>Begin</div><div><br></div><div>do a query</div><div>set=
 timeout=C2=A0</div><div>Exception</div><div>report a record</div><div><br>=
</div><div>End;</div><div><br></div><div>Regards,</div><div>David</div></di=
v>
</div></div>

--0000000000007e7fbb05de9dd577--