nested transaction
От | Rodríguez Rodríguez, Pere |
---|---|
Тема | nested transaction |
Дата | |
Msg-id | B35596C2EFF3D2118EE100A0C94B2A60014BFB18@palamos_nt обсуждение исходный текст |
Ответы |
Re: nested transaction
Re: nested transaction |
Список | pgsql-general |
Hello,
The new release includes savepoints, but I need to do a begin inside another begin and a commit/rollback after another commit/rollback.
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?
Is possible to detect from pA that there is a transaction and so do a savepoint instead of a begin?
Thanks in advance,
pere
В списке pgsql-general по дате отправления: