Thread: transaction isolation level in plpgsql function

transaction isolation level in plpgsql function

From
"Sergey Moroz"
Date:
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.

--
Sincerely,
Sergey Moroz

Re: transaction isolation level in plpgsql function

From
"Pavan Deolasee"
Date:


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.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com

Re: transaction isolation level in plpgsql function

From
"Grzegorz Jaśkiewicz"
Date:
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.