Re: Catch exceptions outside function

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Catch exceptions outside function
Date: 2013-09-18 13:52:33
Message-ID: B0F42216-0C44-44EE-9153-B34FB59A0A5E@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sep 18, 2013, at 7:23 AM, David Johnston <polobo(at)yahoo(dot)com> 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 may be the case OP doesn't even realize there's an open transaction, which must eventually be committed or rolled back...

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Roberto Grandi 2013-09-18 15:12:01 Re: Catch exceptions outside function
Previous Message Igor Neyman 2013-09-18 13:37:12 Re: Catch exceptions outside function