From 1a251b1998dc46dbe0bb6425cb0d7c7c8ad9ae18 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Mon, 18 Aug 2014 11:49:44 +0200 Subject: [PATCH] =?utf8?q?PgUpgrade:=20nicht=20w=C3=A4hrend=20eines=20Upgr?= =?utf8?q?ades=20commiten?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/taxzone_sortkey.pl | 3 --- 1 file changed, 3 deletions(-) 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); -- 2.20.1