From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | Joseph Syjuco <joseph(at)asti(dot)dost(dot)gov(dot)ph>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: transaction in plpgsql |
Date: | 2002-06-28 15:36:12 |
Message-ID: | web-1560422@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Joseph,
> so does that mean that if i call function 2 from function 1 and
> function
> 2 fails than function 1 and function 2 rolls back
>
> hopefully the answer is yes
That's correct. To diagram:
Function 1 calls
|
V
Function 2 calls
|
V
Function 3, which fails
|
V
Function 3 is rolled back
|
V
Function 2 is rolled back
|
V
Function 1 is rolled back
While this automatic tranactioning and "All succeed or fail together"
functionality is sometimes useful, its often also a major annoyance.
Changing it is on the "todo" list, but poses some major technical
challenges.
-Josh Berkus
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2002-06-28 15:44:45 | Re: graphical interface - admin |
Previous Message | Josh Berkus | 2002-06-28 15:30:45 | Re: graphical interface - admin |