Re: transaction isolation level in plpgsql function

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
Cc: "Sergey Moroz" <smo(at)mgcp(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: transaction isolation level in plpgsql function
Date: 2008-11-21 09:49:37
Message-ID: 2f4958ff0811210149w13f61b6dge560e6d71df04783@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcus Engene 2008-11-21 10:05:36 Re: where in (select array)
Previous Message Magnus Hagander 2008-11-21 09:22:12 Re: Postgres mail list traffic over time