From Bugzilla Helper: User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20040808 Firefox/0.9.3 Description of problem: SET AUTOCOMMIT TO OFF is no longer supported. This functionality works fine with postgresql-7.3.4-3. Version-Release number of selected component (if applicable): postgresql-jdbc-7.4.5-2 How reproducible: Always Steps to Reproduce: 1.Install any java app that uses SET AUTOCOMMIT TO OFF 2.Run process that tries to SET AUTOCOMMIT TO OFF 3. Actual Results: java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported Expected Results: No error Additional info: Appears the postgres guys may have resolved this, but you guys would have better access than I :-) You may also want to the separate postgresql components to bugzilla.
This is not a bug; it's a deliberate upstream change. If you have a JDBC driver that is using SET AUTOCOMMIT, you need to update to a 7.4-compatible driver. If you have an application that is using SET AUTOCOMMIT, it's broken in itself, because only the driver should be messing with that.