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
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? |