savepoints - Mailing list pgsql-admin

From Sriram Dandapani
Subject savepoints
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF03EF4740@ca-mail1.cis.local
Whole thread Raw
Responses Re: savepoints  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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.

pgsql-admin by date:

Previous
From: Darcy Buskermolen
Date:
Subject: Re: Autovacuum ideas
Next
From: Alvaro Herrera
Date:
Subject: Re: savepoints