"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.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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings