Title: nested transaction
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 end
Thapliyal, Deepak wrote:
Hi,
Assume I have a bank app.. When customer withdraws $10 from his accouint I
have to do following
--> update account_summary table [subtract $10 from his account]
--> update account detail_table [with other transaction details]
Requirement:
either both transactions
On 14/01/2004 00:17 Nigel J. Andrews wrote:
On Tue, 13 Jan 2004, Thapliyal, Deepak wrote:
> Thx Nigel..
>
> Also can you kindly advice how to turn autocommit to off
Probably:
SET AUTOCOMMIT TO OFF;
although I'm not sure that is still there in 7.4 and there was a lot of
discussion on it's 'broken
On Wed, Jan 14, 2004 at 02:45:38PM +0700, Chris Travers wrote:
> I was thinking about the nested transaction problem, and I came across an
> interesting insight. While it is true you could use dblink to perform db
> operations outside the transaction (which could be useful for logging, etc.)
> wha
I was thinking about the nested transaction problem, and I came across an
interesting insight. While it is true you could use dblink to perform db
operations outside the transaction (which could be useful for logging, etc.)
what is lacking is a way to roll back the internal transactions when the
p
On Tuesday 13 January 2004 17:47, Thapliyal, Deepak wrote:
> Hi,
>
> Assume I have a bank app.. When customer withdraws $10 from his accouint I
> have to do following
> --> update account_summary table [subtract $10 from his account]
> --> update account detail_table [with other transac
ubject: Re: [GENERAL] Nested transaction - I am a bank ??
Thapliyal, Deepak wrote:
>Hi,
>
>Assume I have a bank app.. When customer withdraws $10 from his
>accouint I have to do following
> --> update account_summary table [subtract $10 from his account]
> --
Thapliyal, Deepak wrote:
Hi,
Assume I have a bank app.. When customer withdraws $10 from his accouint I
have to do following
--> update account_summary table [subtract $10 from his account]
--> update account detail_table [with other transaction details]
Requirement:
either both transaction
Hi,
Assume I have a bank app.. When customer withdraws $10 from his accouint I
have to do following
--> update account_summary table [subtract $10 from his account]
--> update account detail_table [with other transaction details]
Requirement:
either both transactions sho
