Re: [GENERAL]transaction isolation level in plpgsql function

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

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

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

[GENERAL] transaction isolation level

We recently updated our postgres to 8.1.4, since then I’ve 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

Re: [GENERAL] transaction isolation level

josh hes. [EMAIL PROTECTED] writes: We recently updated our postgres to 8.1.4, since then I’ve 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

Re: [GENERAL] transaction isolation level

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.4,

[GENERAL] Transaction Isolation Level

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

Re: [GENERAL] Transaction Isolation Level

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 ? --- Note: