Re: nested transaction

Am Dienstag, 10. August 2004 13:30 schrieb "Rodríguez Rodríguez, Pere":
> For example, I have a pA procedure that update some data, so this procedure
> execute a begin, after manipulate data and ends with commit/rollback. pA
> procedure can to be called directly by the client aplication. In other
> hand, I have a pB procedure that also update some data and calls pA
> procedure, so pB procedure execute a begin, after manipulate data, after
> call pA procedure and ends with commit/rollback. pB procedure can also to
> be called directly by the client aplication.
>
> The problem is that pA procedure can't do a new transaction, so what can I
> do?

Use savepoints all the time.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/