transaction isolation level in plpgsql function

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

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.