savepoints

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: savepoints
Date: 2006-04-12 17:22:26
Message-ID: 6992E470F12A444BB787B5C937B9D4DF03EF4740@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This is the scenario:

Controller function fncCtrl calls function A, function B and function C
in that order.

Function A needs a savepoint to prevent errors from undoing work that
needs to be committed regardless of errors in function B or C

Is there a way to define a generic savepoint that any errors in B or C
will rollback to.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2006-04-12 17:29:47 Re: savepoints
Previous Message Darcy Buskermolen 2006-04-12 15:39:08 Re: Autovacuum ideas