Re: Ending transaction inside stored function

From: "Chris Travers" <chris(at)travelamericas(dot)com>
To: <lnd(at)hnit(dot)is>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Ending transaction inside stored function
Date: 2004-01-22 09:38:08
Message-ID: 01f701c3e0cc$1dbd20b0$bf285e3d@winxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mattias Kregert 2004-01-22 09:58:39 Re: Lost plpgsql function
Previous Message Chris Travers 2004-01-22 09:25:11 Re: OT: SCO Extortion