On Saturday 30 June 2007 23:52, Postgres User wrote:
> How about this scenario:
> func A()
> x = func B();
> y = func C();
> z = func D();
> 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
> 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.
In response to
pgsql-general by date
|Next:||From: cluster||Date: 2007-06-30 23:23:57|
|Subject: Bitmap index?|
|Previous:||From: Postgres User||Date: 2007-06-30 21:53:13|
|Subject: Re: Do Postgres exceptions rise up the stack?|