Thread: transaction isolation level in plpgsql function

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

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

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.