Re: Nested transaction - I am a bank ??

On Tue, 13 Jan 2004, Joshua D. Drake wrote:

> 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 should succeed or both transactions should
> >be rolled back in case of failure.
> >
> >Question: 
> >	if my first update succeeds and second fails (say due to space
> >errors .. I have inconsistancy ..
> >  
> >
> 
> Not if you run the queries as a single transaction.
> 
> 
> >Per the thread below stored procedures/functions cannot have commits. I
> >assume that means that they will be implicitly commited ??
> >
> >How do I approach this simple requirment using psql ? 

Joshua, aren't functions run within their own transactions if they don't 
inherit one?  Wouldn't that take care of this part as well?