X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/a23454bb1b039a31b7f77710ff663fa9152d530c..de009a3fee7e0471c3e095ce92d8708ff2b42597:/sql/Pg-upgrade2/globalprojectnumber_ap_ar_oe.pl diff --git a/sql/Pg-upgrade2/globalprojectnumber_ap_ar_oe.pl b/sql/Pg-upgrade2/globalprojectnumber_ap_ar_oe.pl index df31c04e4..f12c92a52 100644 --- a/sql/Pg-upgrade2/globalprojectnumber_ap_ar_oe.pl +++ b/sql/Pg-upgrade2/globalprojectnumber_ap_ar_oe.pl @@ -19,8 +19,8 @@ sub run { "ALTER TABLE oe ADD COLUMN globalproject_id integer;", "ALTER TABLE oe ADD FOREIGN KEY (globalproject_id) REFERENCES project (id);"); - $self->db_query("ALTER TABLE project ADD PRIMARY KEY (id);", 1); - map({ $self->db_query($_, 0); } @queries); + $self->db_query("ALTER TABLE project ADD PRIMARY KEY (id)", may_fail => 1); + $self->db_query($_) for @queries; return 1; }