Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql 3 May 2015 12:32:28 -0000 1.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql 3 May 2015 12:40:38 -0000 1.2 @@ -57,12 +57,13 @@ ALTER TABLE cr_items ADD CONSTRAINT cr_items_latest_fk FOREIGN KEY (latest_revision) REFERENCES cr_revisions(revision_id) on delete set null; -ALTER TABLE cr_items DROP CONSTRAINT cr_items_live_fk +ALTER TABLE cr_items DROP CONSTRAINT cr_items_live_fk; ALTER TABLE cr_items ADD CONSTRAINT cr_items_live_fk FOREIGN KEY (live_revision) REFERENCES cr_revisions(revision_id) on delete set null; DROP INDEX if exists CR_CHILD_RELS_kids_IDx; +DROP INDEX if exists cr_child_rels_child_id_idx; CREATE INDEX cr_child_rels_child_id_idx on cr_child_rels(child_id); --