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.40.2.3 -r1.40.2.4
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	12 Jan 2006 03:20:29 -0000	1.40.2.3
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	10 Apr 2006 19:31:05 -0000	1.40.2.4
@@ -607,7 +607,7 @@
                     and ot2.object_type <> ''content_revision''
                     and ot1.object_type = refresh_trigger__content_type
                     and ot1.tree_sortkey between ot2.tree_sortkey and tree_right(ot2.tree_sortkey)
-                  order by level desc
+                  order by level asc
   LOOP
     rule_text := rule_text || '' '' || content_type__trigger_insert_statement(type_rec.object_type) || '';'';
   end loop;