From 83ec7ab533431788df3098d493a7f11e3ca71aec Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Sun, 4 Dec 2011 16:35:20 -0500 Subject: [PATCH] commenting out line that tries to create primary key on table that already has that primary key. GRRRR --- Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql index 2cc4293a85..38bc26b477 100644 --- a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql @@ -17472,7 +17472,9 @@ ALTER TABLE serial.unit -- Now rebuild the constraints dropped via cascade. -- ALTER TABLE acq.provider ADD CONSTRAINT provider_edi_default_fkey FOREIGN KEY (edi_default) REFERENCES acq.edi_account (id) DEFERRABLE INITIALLY DEFERRED; DROP INDEX IF EXISTS money.money_mat_summary_id_idx; -ALTER TABLE money.materialized_billable_xact_summary ADD PRIMARY KEY (id); + +-- PINES: this primary key already exists: +-- ALTER TABLE money.materialized_billable_xact_summary ADD PRIMARY KEY (id); -- ALTER TABLE staging.billing_address_stage ADD PRIMARY KEY (row_id); -- 2.11.0