Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql,v diff -u -N -r1.40.2.2 -r1.40.2.3 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql 3 Dec 2005 20:57:16 -0000 1.40.2.2 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql 12 Jan 2006 03:20:29 -0000 1.40.2.3 @@ -669,6 +669,8 @@ from acs_object_types ot1, acs_object_types ot2 where ot2.object_type <> ''acs_object'' and ot2.object_type <> ''content_revision'' + and lower(ot2.table_name) <> ''acs_objects'' + and lower(ot2.table_name) <> ''cr_revisions'' and ot1.object_type = refresh_view__content_type and ot1.tree_sortkey between ot2.tree_sortkey and tree_right(ot2.tree_sortkey) order by ot2.tree_sortkey desc