Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VMIBN-0005iJ-Kp for pgsql-admin@arkaria.postgresql.org; Wed, 18 Sep 2013 13:52:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VMIBM-0000vl-Sw for pgsql-admin@arkaria.postgresql.org; Wed, 18 Sep 2013 13:52:40 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VMIBM-0000vf-4J for pgsql-admin@postgresql.org; Wed, 18 Sep 2013 13:52:40 +0000 Received: from asbnvacz-mailrelay01.megapath.net ([207.145.128.243]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VMIBI-0001m4-VH for pgsql-admin@postgresql.org; Wed, 18 Sep 2013 13:52:39 +0000 Received: from mail8.sea5.speakeasy.net (mail8.sea5.speakeasy.net [69.17.117.53]) by asbnvacz-mailrelay01.megapath.net (Postfix) with ESMTP id AC1871EE4F86 for ; Wed, 18 Sep 2013 09:52:35 -0400 (EDT) Received: (qmail 4314 invoked from network); 18 Sep 2013 13:52:35 -0000 Received: by simscan 1.4.0 ppid: 31088, pid: 11276, t: 1.2225s scanners: clamav: 0.88.2/m:52/d:13495 spam: 3.0.4 Received: from unknown (HELO [192.168.4.16]) (sribe@elevated-dev.com@[205.170.118.135]) (envelope-sender ) by mail8.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 18 Sep 2013 13:52:34 -0000 Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 6.5 \(1508\)) Subject: Re: Catch exceptions outside function From: Scott Ribe In-Reply-To: <1379510613320-5771426.post@n5.nabble.com> Date: Wed, 18 Sep 2013 07:52:33 -0600 Content-Transfer-Encoding: quoted-printable Message-Id: References: <452256586.387717.1379499437400.JavaMail.root@trovaprezzi.it> <515129598.391580.1379505217287.JavaMail.root@trovaprezzi.it> <1379510613320-5771426.post@n5.nabble.com> To: "pgsql-admin@postgresql.org" X-Mailer: Apple Mail (2.1508) X-Spam-Checker-Version: SpamAssassin 3.0.4 (2005-06-05) on mail8.sea5 X-Spam-Level: X-Spam-Status: No, score=0.5 required=8.0 tests=TO_ADDRESS_EQ_REAL autolearn=disabled version=3.0.4 X-Pg-Spam-Score: 0.8 (/) 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 On Sep 18, 2013, at 7:23 AM, David Johnston wrote: > If an exception gets that far your transaction > has failed and you have to ROLLBACK. Right, and after my prior post where I suggested rollback, I realized, it m= ay be the case OP doesn't even realize there's an open transaction, which m= ust eventually be committed or rolled back... --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin