Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VMEuW-0006ea-BY for pgsql-admin@arkaria.postgresql.org; Wed, 18 Sep 2013 10:23:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VMEuV-0003v2-6j for pgsql-admin@arkaria.postgresql.org; Wed, 18 Sep 2013 10:23:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VMEuT-0003ut-6N for pgsql-admin@postgresql.org; Wed, 18 Sep 2013 10:23:01 +0000 Received: from mail.trovaprezzi.it ([2.228.21.217]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VMEuQ-0008HX-HD for pgsql-admin@postgresql.org; Wed, 18 Sep 2013 10:23:00 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.trovaprezzi.it (Postfix) with ESMTP id 015A082024 for ; Wed, 18 Sep 2013 12:17:18 +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 QPkkfrT97cFL for ; Wed, 18 Sep 2013 12:17:17 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by mail.trovaprezzi.it (Postfix) with ESMTP id B99818202C for ; Wed, 18 Sep 2013 12:17:17 +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 zc2B5IeKj1Za for ; Wed, 18 Sep 2013 12:17:17 +0200 (CEST) Received: from zimbra.7pixel.local (zimbra.7pixel.local [192.168.0.127]) by mail.trovaprezzi.it (Postfix) with ESMTP id 7CD4C82024 for ; Wed, 18 Sep 2013 12:17:17 +0200 (CEST) Date: Wed, 18 Sep 2013 12:17:17 +0200 (CEST) From: Roberto Grandi To: pgsql-admin@postgresql.org Message-ID: <452256586.387717.1379499437400.JavaMail.root@trovaprezzi.it> In-Reply-To: <1725603904.387654.1379499282544.JavaMail.root@trovaprezzi.it> Subject: Catch exceptions outside function 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: Catch exceptions outside function Thread-Index: glZu2ImBDkpEo87LW1ODUNYiVViPYQ== X-Pg-Spam-Score: -2.6 (--) 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 ask for your help cause I can't point out the solution to my problem on PG 8.3 I would catch an exception outside any function/procedure but directly within script. BEGIN; -- raise an exception code EXCEPTION WHEN 'exception_type' THEN ROLLBACK; COMMIT; is it possible with PG 8.3? Many thanks in advance. Roberto -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin