X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Ftaxzone_sortkey.pl;h=7b1c4ce3e2c5a484314b4067fad407e1021906ab;hb=577042c61c5e1fffb8747079b4f9826e51532ee8;hp=88897d7af3bc9f2c9c4fc4570ebd4727fc7ba52d;hpb=f5c454e3855012bdb1928f3e4c4964403d4d8163;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/taxzone_sortkey.pl b/sql/Pg-upgrade2/taxzone_sortkey.pl index 88897d7af..7b1c4ce3e 100644 --- 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); - $self->dbh->commit; my $sortkey = 1; $query = qq|SELECT * FROM tax_zones ORDER BY id|; @@ -29,8 +28,6 @@ sub run { } $sth->finish; - $self->dbh->commit; - $query = qq|ALTER TABLE tax_zones ALTER COLUMN sortkey SET NOT NULL|; $self->db_query($query);