Re: [GENERAL]transaction isolation level in plpgsql function

2008-11-21 Thread Pavan Deolasee
On Fri, Nov 21, 2008 at 1:19 PM, Sergey Moroz [EMAIL PROTECTED] 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

Re: [GENERAL]transaction isolation level in plpgsql function

2008-11-21 Thread Grzegorz Jaƛkiewicz
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.

[GENERAL]transaction isolation level in plpgsql function

2008-11-20 Thread Sergey Moroz
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