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.
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 transacti
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
My guess would be that you are getting the connection with autocommit
(false);
Either way try
conn = getConn...
conn.setAutoCommit(false);
conn.changeTransactionLevel
On 29-Aug-06, at 9:15 AM, Tom Lane wrote:
"josh hes." <[EMAIL PROTECTED]> writes:
We recently updated our postgres to 8.1.
"josh hes." <[EMAIL PROTECTED]> writes:
> We recently updated our postgres to 8.1.4, since then
> Ive been getting the following error:
> [Aug 28, 2006 5:43:16 AM ERROR]
> org.postgresql.util.PSQLException: Cannot change
> transaction isolation level in the middle of a
> transaction.
> at
> org.
We recently updated our postgres to 8.1.4, since then
Ive been getting the following error:
[Aug 28, 2006 5:43:16 AM ERROR]
org.postgresql.util.PSQLException: Cannot change
transaction isolation level in the middle of a
transaction.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionI
On Thu, 25 Mar 2004, Grace C. Unson wrote:
> Hello.
>
> How is it possible that ResultSetObjInstance in this statement
>
> ResultSetObjInstance = PreparedObjInstance.executeQuery()
>
> contains this column and value respectively:
>
> TRANSACTION ISOLATION LEVEL , READ_COMMITTED ?
>
> ---
>
Hello.
How is it possible that ResultSetObjInstance in this statement
ResultSetObjInstance = PreparedObjInstance.executeQuery()
contains this column and value respectively:
TRANSACTION ISOLATION LEVEL , READ_COMMITTED ?
---
Note:
During the query operation, lots of write operations are going
