Postgres Pro
Downloads
Home   >   mailing lists

Re: transaction isolation level in plpgsql function - Mailing list pgsql-general

From Pavan Deolasee
Subject Re: transaction isolation level in plpgsql function
Date
Msg-id 2e78013d0811210120w50449b2cv6f07a2bbcc9516ef@mail.gmail.com
Whole thread Raw
In response to transaction isolation level in plpgsql function  ("Sergey Moroz" <smo@mgcp.com>)
Responses Re: transaction isolation level in plpgsql function
List pgsql-general
Tree view


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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: where in (select array)
Next
From: Magnus Hagander
Date:
Subject: Re: Postgres mail list traffic over time