Bug #7767 for DBD-Pg: from gborg: postgres.conf autocommit=false disrupts autocommit

Fri Sep 24 22:44:49 2004 Guest - Ticket created

Subject:

from gborg: postgres.conf autocommit=false disrupts autocommit

[ this bug has been migrated from Gborg. A new comment is below. ] Environment: Solaris 8 perl 5.8.0 DBD::Pg 1.2.2, 1.1.3 PostgreSQL 7.3.3 Description: If postgres.conf autocommit=false is set, then AutoCommit => 1 settings fail to commit. AutoCommit => 0 followed by a $dbh->commit works. Dave S. ### mstemle@stu.parkland.edu : 06/19/2003 I would definately say that this **IS A CRITICAL BUG**. I don't know why autocommit=false is a new feature in PGSQL, but autocommit should NEVER be on. I **REALLY** need this bug to be solved to eliminate the headaches we have here at this college. Thank you. ############################ Could you test this with a current snapshot from CVS? I have one prepared here: http://mark.stosberg.com/perl/DBD-Pg-cvs-2004-09-24.tgz Your testing will help insure this issue is fixed in the upcoming release.

Thu Mar 31 17:47:40 2005 ivan-pause [...] 420.am - Correspondence added

From:

Ivan Kohler

Please let us know if this is fixed in 1.40_1: http://search.cpan.org/~dbdpg/DBD-Pg-1.40_1/ or direct link to a download: http://search.cpan.org/CPAN/authors/id/D/DB/DBDPG/DBD-Pg-1.40_1.tar.gz Thanks! [guest - Fri Sep 24 22:44:49 2004]: Show quoted text

> [ this bug has been migrated from Gborg. A new comment is below. ] > > Environment: > > Solaris 8 > perl 5.8.0 > DBD::Pg 1.2.2, 1.1.3 > PostgreSQL 7.3.3 > > Description: > > If postgres.conf autocommit=false is set, then AutoCommit => 1 > settings fail to commit. AutoCommit => 0 followed by a

$dbh->commit Show quoted text

> works. > > Dave S. > > ### > > mstemle@stu.parkland.edu : 06/19/2003 > > I would definately say that this **IS A CRITICAL BUG**. I don't > know why autocommit=false is a new feature in PGSQL, but

autocommit Show quoted text

> should NEVER be on. I **REALLY** need this bug to be solved to > eliminate the headaches we have here at this college. Thank you. > > ############################ > > Could you test this with a current snapshot from CVS? I have one > prepared here: > > http://mark.stosberg.com/perl/DBD-Pg-cvs-2004-09-24.tgz > > Your testing will help insure this issue is fixed in the upcoming > release. > > >

Fri Jun 17 12:56:19 2005 dbd-pg [...] perl.org - Status changed from 'new' to 'resolved'

Fri Jun 17 12:56:19 2005 dbd-pg [...] perl.org - Fixed in 1.22 added