Re: Ending transaction inside stored function - Mailing list pgsql-general

From Chris Travers
Subject Re: Ending transaction inside stored function
Date
Msg-id 01f701c3e0cc$1dbd20b0$bf285e3d@winxp
Whole thread Raw
In response to Ending transaction inside stored function  (<lnd@hnit.is>)
List pgsql-general
> Is there any way to end (commit/rollback) a transaction inside a stored
> function?

Currently not, but you can RAISE EXCEPTION to terminate the containing
transaction.  This will essentially rollback the transaction when it hits
the COMMIT statement (or implied version).

Best Wishes,
Chris Travers


pgsql-general by date:

Previous
From: "Chris Travers"
Date:
Subject: Re: OT: SCO Extortion
Next
From: "Mattias Kregert"
Date:
Subject: Re: Lost plpgsql function