X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/f5c454e3855012bdb1928f3e4c4964403d4d8163..b720e272:/sql/Pg-upgrade2/taxzone_sortkey.pl 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);