Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VLy9C-0003PL-41 for pgsql-admin@arkaria.postgresql.org; Tue, 17 Sep 2013 16:29:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VLy9B-0001Ql-Kd for pgsql-admin@arkaria.postgresql.org; Tue, 17 Sep 2013 16:29:05 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VLy9A-0001Qf-PE for pgsql-admin@postgresql.org; Tue, 17 Sep 2013 16:29:05 +0000 Received: from mail.trovaprezzi.it ([2.228.21.217]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VLy97-000497-Fw for pgsql-admin@postgresql.org; Tue, 17 Sep 2013 16:29:03 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.trovaprezzi.it (Postfix) with ESMTP id 69FA982005 for ; Tue, 17 Sep 2013 18:23:23 +0200 (CEST) X-Virus-Scanned: amavisd-new at zimbra.7pixel.local Received: from mail.trovaprezzi.it ([127.0.0.1]) by localhost (zimbra.7pixel.local [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id oUGes8TtGREa for ; Tue, 17 Sep 2013 18:23:23 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by mail.trovaprezzi.it (Postfix) with ESMTP id 2D4BF82009 for ; Tue, 17 Sep 2013 18:23:23 +0200 (CEST) X-Virus-Scanned: amavisd-new at zimbra.7pixel.local Received: from mail.trovaprezzi.it ([127.0.0.1]) by localhost (zimbra.7pixel.local [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id AMbAQhbTvomV for ; Tue, 17 Sep 2013 18:23:22 +0200 (CEST) Received: from zimbra.7pixel.local (zimbra.7pixel.local [192.168.0.127]) by mail.trovaprezzi.it (Postfix) with ESMTP id DE3F482005 for ; Tue, 17 Sep 2013 18:23:22 +0200 (CEST) Date: Tue, 17 Sep 2013 18:23:22 +0200 (CEST) From: Roberto Grandi To: pgsql-admin@postgresql.org Message-ID: <326366447.356781.1379435002810.JavaMail.root@trovaprezzi.it> In-Reply-To: <1327626325.356780.1379434995993.JavaMail.root@trovaprezzi.it> Subject: Script timeout MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [91.204.80.113] X-Mailer: Zimbra 8.0.2_GA_5569 (ZimbraWebClient - FF23 (Win)/8.0.2_GA_5569) Thread-Topic: Script timeout Thread-Index: bZu5LCz70APoBZY+eXmlQ7sTCflArQ== X-Pg-Spam-Score: 0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Dear all, i would set a script timeout from a .net application. My problem regards how to make sure that time out will be reset at the end of the script such as SET statement_timeout 1000 SELECT pg_sleep(2); trowhs exception After that SELECT pg_sleep(2); wouldn't throw exception. Can you help me to solve this issue? Many thanks in advance. BR Roberto -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin