Re: function transaction scope question

On Wed, Jan 14, 2009 at 9:41 AM, Wright, George
<George(dot)Wright(at)infimatic(dot)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."