PgUpgrade: nicht während eines Upgrades commiten

diff --git a/sql/Pg-upgrade2/taxzone_sortkey.pl b/sql/Pg-upgrade2/taxzone_sortkey.pl
index 88897d7af3bc9f2c9c4fc4570ebd4727fc7ba52d..7b1c4ce3e2c5a484314b4067fad407e1021906ab 100644 (file)
--- a/sql/Pg-upgrade2/taxzone_sortkey.pl
+++ b/sql/Pg-upgrade2/taxzone_sortkey.pl
@@ -15,7 +15,6 @@ sub run {
 
   my $query = qq|ALTER TABLE tax_zones ADD COLUMN sortkey INTEGER|;
   $self->db_query($query);
 
   my $query = qq|ALTER TABLE tax_zones ADD COLUMN sortkey INTEGER|;
   $self->db_query($query);

-  $self->dbh->commit;

 
   my $sortkey = 1;
   $query = qq|SELECT * FROM tax_zones ORDER BY id|;
 
   my $sortkey = 1;
   $query = qq|SELECT * FROM tax_zones ORDER BY id|;


@@ -29,8 +28,6 @@ sub run {
   }
   $sth->finish;
 
   }
   $sth->finish;
 

-  $self->dbh->commit;
-

   $query = qq|ALTER TABLE tax_zones ALTER COLUMN sortkey SET NOT NULL|;
   $self->db_query($query);
 
   $query = qq|ALTER TABLE tax_zones ALTER COLUMN sortkey SET NOT NULL|;
   $self->db_query($query);