Isolation and Concurrency in PG functions?

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Isolation and Concurrency in PG functions?
Date: 2000-09-11 05:02:17
Message-ID: 39BC6759.55DAF82F@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)cc(dot)usu(dot)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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dronamraju Rajesh 2000-09-11 06:51:39 what utilities do i need for postgres on solaris 7 ??
Previous Message Max Pyziur 2000-09-11 03:16:19 Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug?