On Fri, Nov 21, 2008 at 1:19 PM, Sergey Moroz <smo@mgcp.com> wrote:
Is there any way to set transaction isolation level inside plpgsql function? In my case I have no control of transaction before function is started.
I don't think there can be any. You are already inside a transaction when plpgsql function is called and there is no way to commit and start new transaction inside plpgsql.
whatever calls the function is responsible for transaction level change, because SELECT BLA(); already by default is wrapped by begin;end; - and you can only change transaction level right after BEGIN; although , I feel your pain, it is not possible.