Isolation and Concurrency in PG functions?
От | Roberto Mello |
---|---|
Тема | Isolation and Concurrency in PG functions? |
Дата | |
Msg-id | 39BC6759.55DAF82F@cc.usu.edu обсуждение исходный текст |
Ответы |
Re: Isolation and Concurrency in PG functions?
|
Список | 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@cc.usu.edu - GNU/Linux Reg.User #96240 Computer Science - Utah State UniversityUSU Free Software andGNU/Linux Club, Presidenthttp://fslc.usu.edu - http://www.brasileiro.net/roberto
В списке pgsql-sql по дате отправления: