Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1noED8-0001HA-Gu for pgsql-sql@arkaria.postgresql.org; Tue, 10 May 2022 00:58:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1noED7-00075q-Ea for pgsql-sql@arkaria.postgresql.org; Tue, 10 May 2022 00:58:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1noED7-000738-3I for pgsql-sql@lists.postgresql.org; Tue, 10 May 2022 00:58:45 +0000 Received: from mail-ed1-x532.google.com ([2a00:1450:4864:20::532]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1noED1-0005qT-C3 for pgsql-sql@lists.postgresql.org; Tue, 10 May 2022 00:58:44 +0000 Received: by mail-ed1-x532.google.com with SMTP id c12so10710202edv.10 for ; Mon, 09 May 2022 17:58:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=1s3lUTTuhpg6QXVg66ftgm1ObJK8Bhaj+Ur5ewPf5Hc=; b=G0bGJ7703Wn3ksU8W8bA/mFDSqmV4Og8ynMTMRPpIOrFSvnNjJkBgKKofYZZ4nCQ58 +4SqZG/+Gzi4jso95qe0kWaxqvR4UIqfgNE5VYrxUYGYN2zbvm47yTfbwxAaS0Etmj5Z STZDF+L6+v7CWf0tJuBDkmz4GhhQkRjFO6hZKwaL3HI9PwF8Aner0y0KUNh45Y9l/OYz 2bbL0pzBqeOC2tufkneV207kZlXdYIMeyREer9JsbIR9jSbb/phYMw3GOofsH4EVXZ6w 8vr6yEiZIWaZYNTXtWdOtbPU1SQny+52hf5NPRl5yQbecO0pGAnL5urVWttsgyPdQKUa IM2g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=1s3lUTTuhpg6QXVg66ftgm1ObJK8Bhaj+Ur5ewPf5Hc=; b=T+QG8bLMAHuPZB0QPbfNjqsCN5mRq6U7FQpAguBLgSYlOuNI4X8djVdFdCHoBfhJMy TaFd4YcmhN6nv5Lc62FOt1sZwGWAbivWGRe07/7qxhIfd7V48FywUZ8hese4owzyEml3 SP+O5uJzCpMPELZCMzRUdXw5pcShcRAVN9/JrCijW7yNyvtFLq2sXIT2O1/vFvAkCDsF t7NAKeFuAHv58FFOxUBESMYUwTbXaVNKPKiepmkTyhqs+EPgiBzzqOI2RmU5w3+km+zA nO9v+ogGVjlzraJ6Kc96memG33fMezOY3sfOlyMQbqXOslZrPvp4yL1I296GImnWl9rs 5UlA== X-Gm-Message-State: AOAM532EWf5Fi0lfjpnMKuUdiKpo2gqCXJJKh9VsZEa4j1BwCjhg8hd0 VhMkfNauLfrBIHl5bfQponNiw5Pmbiql9sRvbdqDQhIv X-Google-Smtp-Source: ABdhPJybGzlW8lwpqqdMhSqsc4YiPJV0mBVmArXVtyEw4jWecaujIRf0k6XTfTAmXewVUp8+X1gakxOmeZn58W3mspA= X-Received: by 2002:a05:6402:1d4a:b0:427:b250:ee56 with SMTP id dz10-20020a0564021d4a00b00427b250ee56mr20551254edb.31.1652144316928; Mon, 09 May 2022 17:58:36 -0700 (PDT) MIME-Version: 1.0 From: Shaozhong SHI Date: Tue, 10 May 2022 01:58:26 +0100 Message-ID: Subject: Set timeout just on a query? To: pgsql-sql Content-Type: multipart/alternative; boundary="00000000000020d5eb05de9dd353" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000020d5eb05de9dd353 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 --00000000000020d5eb05de9dd353 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Can timeout be set just on a query?

Can= we do the following?

Begin

do a query
set timeout=C2=A0
Exception
rep= ort a record

End;

Regards= ,
David
--00000000000020d5eb05de9dd353--