From: | "Rodríguez Rodríguez, Pere" <prr(at)hosppal(dot)es> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | nested transaction |
Date: | 2004-08-10 11:30:20 |
Message-ID: | B35596C2EFF3D2118EE100A0C94B2A60014BFB18@palamos_nt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2004-08-10 11:40:49 | Re: PostgreSQL 8.0.0 Officially Goes Beta |
Previous Message | ra | 2004-08-10 11:28:07 | Re: Listing views |