Re: Transactions: DBI vs. SQL

[Martin J. Evans]

Tom Mornini wrote:
You need to turn AutoCommit off with:
    my $dbh = DBI->connect('dbi:Pg:dbname=test', 'postgres', '...',
                           { PrintError => 1, RaiseError => 0,  
AutoCommit => 0 });



You should not have to turn autocommit off with begin_work:

From the docs:

"Enable transactions (by turning AutoCommit off) until the next call to 
commit or rollback. After the next commit or rollback, AutoCommit will 
automatically be turned on again."

I certainly do not turn autocommit off with DBD::ODBC and dbd::mysql
and it works as I'd expect.

Martin