nested transaction

[Rodríguez Rodríguez, Pere]

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

[Peter Eisentraut]

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/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Tom Lane]

=?ISO-8859-1?Q?=22Rodr=EDguez_Rodr=EDguez=2C_Pere=22?= <pr*@hosppal.es> writes:

Is possible to detect from pA that there is a transaction and so do a
savepoint instead of a begin?

Depends on what you're programming in, but in principle yes. If using
libpq, see PQtransactionStatus().

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)