Forum OpenACS Q&A: Concurrency in PG functions

Collapse
Posted by Roberto Mello on
Hi all,

Can somebody tell us about concurrency in PG functions?

I am porting some VERY big functions and it seems that the results of
one portion of the function (e.g. a create table or a series of
inserts) are invisible to the other parts which obviously causes the
function to fail and is completely driving me nuts because I see the
results when I do the queries interactively.

This becomes worse because transactions are not supported in
functions.  Any help is GREATLY appreciated.