Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 133631 - SET AUTOCOMMIT TO OFF is no longer supported
SET AUTOCOMMIT TO OFF is no longer supported
Product: Fedora
Classification: Fedora
Component: postgresql (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Tom Lane
David Lawrence
Depends On:
  Show dependency treegraph
Reported: 2004-09-25 07:52 EDT by Ted Kaczmarek
Modified: 2013-07-02 23:02 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2004-09-25 12:57:02 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Ted Kaczmarek 2004-09-25 07:52:06 EDT
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):

How reproducible:

Steps to Reproduce:
1.Install any java app that uses SET AUTOCOMMIT TO OFF
2.Run process that tries to SET AUTOCOMMIT TO OFF

Actual Results:  java.sql.SQLException: ERROR:  SET AUTOCOMMIT TO OFF
is no longer

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.
Comment 1 Tom Lane 2004-09-25 12:57:02 EDT
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.

Note You need to log in before you can comment on or make changes to this bug.