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 some major technical
challenges.

-Josh Berkus