| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | "Thapliyal, Deepak" <dthapliyal(at)soe(dot)sony(dot)com>, "'Richard Huxton'" <dev(at)archonet(dot)com>, <Anton(dot)Nikiforov(at)loteco(dot)ru>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Nested transaction - I am a bank ?? |
| Date: | 2004-01-13 18:34:20 |
| Message-ID: | Pine.LNX.4.33.0401131133460.22622-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-01-13 18:34:52 | Re: Pl/Perl speed |
| Previous Message | Tom Lane | 2004-01-13 18:24:45 | Re: Best practice? Web application: single PostgreSQL |