Bug 133631 – SET AUTOCOMMIT TO OFF is no longer supported

Bug 133631 - SET AUTOCOMMIT TO OFF is no longer supported

Summary:	SET AUTOCOMMIT TO OFF is no longer supported

Status:	CLOSED NOTABUG

Aliases:	None

Product:	Fedora
Classification:	Fedora
Component:	postgresql (Show other bugs)
Sub Component:
Version:	2
Hardware:	All Linux

Priority	medium Severity medium
Target Milestone:	---
Target Release:	---
Assigned To:	Tom Lane
QA Contact:	David Lawrence
Docs Contact:

URL:	http://archives.postgresql.org/pgsql-...
Whiteboard:
Keywords:

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2004-09-25 07:52 EDT by Ted Kaczmarek
Modified:	2013-07-02 23:02 EDT (History)
CC List:	1 user (show)

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

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

Groups: 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):
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.

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.