Re: transaction isolation level

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "josh hes(dot)" <jbhester(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: transaction isolation level
Date: 2006-08-29 13:15:31
Message-ID: 3707.1156857331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"josh hes." <jbhester(at)yahoo(dot)com> 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.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(AbstractJdbc2Connection.java:729)

Updated to 8.1.4 from what?

You'll probably have better luck asking on the pgsql-jdbc list (and
mentioning which jdbc driver versions are involved). This looks to me
like it's associated with a change in driver behavior not backend
behavior.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Silvela, Jaime (Exchange) 2006-08-29 13:29:04 Re: speeding up big query lookup
Previous Message Douglas McNaught 2006-08-29 13:12:35 Re: database files are incompatible with server, after