Re: Do Postgres exceptions rise up the stack? - Mailing list pgsql-general

On Saturday 30 June 2007 23:52, Postgres User wrote:

> How about this scenario:
>
> func A()
>
> begin
>    x  =  func B();
>    y  =  func C();
>
>    z = func D();
>
> end
>
> Where func A, B, C, and D all update the db.  If a funciton is raised
> in func D(), will all the transactions in the other children be rolled
> back?
> Or do I need to add code to enable this?

(Noted correction in other reply).

It will be rolled back. When you don't begin a transaction explicitly,
postgresql creates one implicitely when you execute a function. So, calling a
function will always be atomic.