Hail PG Gurus, Can somebody please tell us about concurrency in PG functions? I am porting some VERY big functions to PG for a data warehousing system (that is GPL'd BTW) 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 (and following functions) to fail and is completely driving me nuts because I see the results when I do the queries interactively. What can I do about this? Is autocommit off in functions? How can I bring it on? This becomes worse because transactions are not supported in functions (anybody knows when will this be around?). Thanks, -Roberto Mello -- Roberto Mello, [EMAIL PROTECTED] - GNU/Linux Reg.User #96240 Computer Science - Utah State University USU Free Software and GNU/Linux Club, President http://fslc.usu.edu - http://www.brasileiro.net/roberto
