Re: [GENERAL] Functions and transactions

2008-04-08 Thread Martijn van Oosterhout
On Tue, Apr 08, 2008 at 03:44:47PM +0200, Giorgio Valoti wrote: > Hi all, the documentation says that functions are always executed > within the transaction established by the outer query. However, I was > quite surprised (in a positive way, that is) seeing that if a > function call cau

[GENERAL] Functions and transactions

2008-04-08 Thread Giorgio Valoti
Hi all, the documentation says that functions are always executed within the transaction established by the outer query. However, I was quite surprised (in a positive way, that is) seeing that if a function call causes some error, the whole function is "rolled back". Is this the expected b