Re: Rollback for aborted function? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Rollback for aborted function?
Date
Msg-id 200307032128.33612.dev@archonet.com
Whole thread Raw
In response to Rollback for aborted function?  (Rory Campbell-Lange <rory@campbell-lange.net>)
List 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

pgsql-general by date:

Previous
From: Mark
Date:
Subject: float formating with xx.00
Next
From: CSN
Date:
Subject: Various serverlog messages