Index: openacs-4/packages/calendar/sql/postgresql/upgrade/upgrade-2.10.0d6-2.10.0d7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/postgresql/upgrade/upgrade-2.10.0d6-2.10.0d7.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/calendar/sql/postgresql/upgrade/upgrade-2.10.0d6-2.10.0d7.sql 11 Dec 2020 19:40:16 -0000 1.1.2.1 +++ openacs-4/packages/calendar/sql/postgresql/upgrade/upgrade-2.10.0d6-2.10.0d7.sql 19 Jan 2021 06:39:13 -0000 1.1.2.2 @@ -1,3 +1,3 @@ -- create a partial index on public calendars -create index calendars_package_id_pidx on calendars(package_id) where private_p = false; +create index if not exists calendars_package_id_pidx on calendars(package_id) where private_p = false;