Skip Menu |
 

This queue is for tickets about the DBD-Pg CPAN distribution.

Report information
The Basics
Id: 82356
Status: resolved
Priority: 0/
Queue: DBD-Pg

People
Owner: greg [...] turnstep.com
Requestors: flimzy [...] flimzy.com
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 2.19.2
Fixed in: 3.0.0



Subject: DBD::Pg documentation appears inaccurate with regard to AutoCommit implementation
Download (untitled) / with headers
text/plain 806b
DBD::Pg documentation says: "DBD::Pg implements AutoCommit by issuing a BEGIN statement immediately before executing a statement, and a COMMIT afterwards." (http://search.cpan.org/~turnstep/DBD-Pg-2.19.3/Pg.pm#Transactions) However, this is not the observed behavior (and for good reason--PostgreSQL's default behavior is the same as AutoCommit) A simple test script demonstrates the inaccuracy of the documentation: --------------- #!/usr/bin/perl use strict; use warnings; use DBI; my $dbh = DBI->connect("dbi:Pg:dbname=test"); print "AutoCommit = $dbh->{AutoCommit}\n"; $dbh->do('INSERT INTO foo(x) VALUES (1)'); --------------- The script's output: AutoCommit = 1 And my PostgreSQL logs (with log_statement = 'all'): 2012-03-05 20:21:02 CST rootLOG: statement: INSERT INTO foo(x) VALUES (1)
Thank you, that is confusing. We will fix it up.
Wording modified in 589e1169ff5160f79ab1641dda207461bd99fa5a


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.