Re: Rollback for aborted function?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Rollback for aborted function?
Date: 2003-07-03 20:28:33
Message-ID: 200307032128.33612.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 03 Jul 2003 3:39 pm, Rory Campbell-Lange wrote:
> If a function generates an exception, do I need to rollback manually?

No - any error will abort a transaction.
In fact, you can't stop it happening - trapping errors is one of the more
common feature requests - possibly available in 7.5, not in the forthcoming
7.4.

--
Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark 2003-07-03 20:28:47 float formating with xx.00
Previous Message scott.marlowe 2003-07-03 20:03:35 Re: Rollback for aborted function?