Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql,v
diff -u -r1.14 -r1.15
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	30 Apr 2001 01:34:58 -0000	1.14
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	9 May 2001 03:31:42 -0000	1.15
@@ -263,9 +263,9 @@
                                          from acs_objects 
                                         where object_id = copy__revision_id)
                   and 
-                    ot2.object_type <= ot1.object_type
+                    ot2.tree_sortkey <= ot1.tree_sortkey
                   and 
-                    ot1.object_type like (ot2.object_type || ''%'')
+                    ot1.tree_sortkey like (ot2.tree_sortkey || ''%'')
                   order by
                     level desc
   LOOP
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 -r1.14 -r1.15
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	28 Apr 2001 19:58:39 -0000	1.14
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	9 May 2001 03:31:42 -0000	1.15
@@ -543,9 +543,9 @@
                   and 
                     ot1.object_type = refresh_trigger__content_type
                   and 
-                    ot2.object_type <= ot1.object_type
+                    ot2.tree_sortkey <= ot1.tree_sortkey
                   and 
-                    ot1.object_type like (ot2.object_type || ''%'')
+                    ot1.tree_sortkey like (ot2.tree_sortkey || ''%'')
                   order by
                     level desc
   LOOP
@@ -608,9 +608,9 @@
                   and 
                     ot1.object_type = refresh_view__content_type
                   and 
-                    ot2.object_type <= ot1.object_type
+                    ot2.tree_sortkey <= ot1.tree_sortkey
                   and 
-                    ot1.object_type like (ot2.object_type || ''%'')
+                    ot1.tree_sortkey like (ot2.tree_sortkey || ''%'')
                   order by
                     ot2.tree_sortkey desc
   LOOP