nested transaction

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

Responses

Browse pgsql-general by date

  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