Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0a1-5.2.0a2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0a1-5.2.0a2.sql,v diff -u -r1.1.2.4 -r1.1.2.5 --- openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0a1-5.2.0a2.sql 21 Jun 2005 17:25:21 -0000 1.1.2.4 +++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0a1-5.2.0a2.sql 27 Oct 2005 17:16:38 -0000 1.1.2.5 @@ -205,11 +205,14 @@ declare ct RECORD; begin - for ct in select object_type - from acs_object_type_supertype_map - where ancestor_type = ''content_revision'' + for ct in select t.object_type,t.table_name + from acs_object_type_supertype_map m, acs_object_types t + where t.object_type = m.object_type + and m.ancestor_type = ''content_revision'' loop - perform content_type__refresh_view (ct.object_type); + if table_exists(ct.table_name) = ''t'' then + perform content_type__refresh_view (ct.object_type); + end if; end loop; return null;