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
somemajor technical
challenges.
-Josh Berkus