Re: transaction in plpgsql

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