Re: function transaction scope question

On Wed, Jan 14, 2009 at 9:41 AM, Wright, George
<George.Wright@infimatic.com> wrote:
> If a function in PL/pgSQL is wrapped by a transaction, does that same single
> transaction encompass other functions defined elsewhere that this function
> calls?

There's a rather stronger condition than that to be claimed...

*EVERY* PostgreSQL stored function call (irrespective of language)
runs within the context of a particular transaction.  That transaction
context will therefore include all of the following:
 - any functions that the stored function may call
 - any triggers that may be fired by virtue of table updates
 - invocation of NOTIFY (but *not* the notifications that result in
listening connections)

That's quite comfortably stronger than what you appear to be hoping for :-).
--
http://linuxfinances.info/info/linuxdistributions.html
Steve Martin  - "I like a woman with a head on her shoulders. I hate necks."