From: ivan Date: Fri, 4 Oct 2002 12:39:29 +0000 (+0000) Subject: turn on AutoCommit when vacuuming X-Git-Tag: freeside_1_5_0pre1~206 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=54a27b35957baddb725e2b7544d9f134989bfd99 turn on AutoCommit when vacuuming --- diff --git a/FS/bin/freeside-daily b/FS/bin/freeside-daily index 22bf2c963..52028b773 100755 --- a/FS/bin/freeside-daily +++ b/FS/bin/freeside-daily @@ -50,6 +50,7 @@ foreach $cust_main ( @cust_main ) { } if ( driver_name eq 'Pg' ) { + dbh->{AutoCommit} = 1; #so we can vacuum foreach my $statement ( 'vacuum', 'vacuum analyze' ) { my $sth = dbh->prepare($statement) or die dbh->errstr; $sth->execute or die $sth->errstr;