Received: from gumby.usu.edu (gumby.usu.edu [129.123.1.117]) by hub.org (8.10.1/8.10.1) with ESMTP id e8B51Rf69895 for ; Mon, 11 Sep 2000 01:01:27 -0400 (EDT) Received: from cc.usu.edu ("port 2906"@slxwy.dorms.usu.edu [129.123.236.160]) by cc.usu.edu (PMDF V5.2-32 #30472) with ESMTP id <01JU0WV592KK9GXQNT@cc.usu.edu> for pgsql-sql@postgresql.org; Sun, 10 Sep 2000 23:01:25 MDT Date: Sun, 10 Sep 2000 23:02:17 -0600 From: Roberto Mello Subject: Isolation and Concurrency in PG functions? To: pgsql-sql@postgresql.org Message-id: <39BC6759.55DAF82F@cc.usu.edu> MIME-version: 1.0 X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.16 i586) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Priority: 1 (Highest) X-Accept-Language: en, pt-BR X-Archive-Number: 200009/62 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, rmello@cc.usu.edu - 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