Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -r1.109.2.32 -r1.109.2.33
--- openacs-4/packages/acs-content-repository/acs-content-repository.info	27 Feb 2017 07:42:02 -0000	1.109.2.32
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info	21 Apr 2017 12:21:35 -0000	1.109.2.33
@@ -9,7 +9,7 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
     
-    <version name="5.9.1b3" url="http://openacs.org/repository/download/apm/acs-content-repository-5.9.1b3.apm">
+    <version name="5.9.1b4" url="http://openacs.org/repository/download/apm/acs-content-repository-5.9.1b4.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>The canonical repository for OpenACS content.</summary>
         <release-date>2017-02-27</release-date>
@@ -21,7 +21,7 @@
         <license>GPL</license>
         <maturity>3</maturity>
 
-        <provides url="acs-content-repository" version="5.9.1b3"/>
+        <provides url="acs-content-repository" version="5.9.1b4"/>
         <requires url="acs-kernel" version="5.9.1b1"/>
         <requires url="acs-service-contract" version="5.9.1b1"/>
         <requires url="acs-tcl" version="5.9.1b1"/>
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql,v
diff -u -r1.72.2.8 -r1.72.2.9
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	27 Nov 2016 10:10:37 -0000	1.72.2.8
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	21 Apr 2017 12:21:35 -0000	1.72.2.9
@@ -1236,6 +1236,8 @@
   v_resolved_root_id               integer;       
   v_path                           text    default '';  
   v_rec                            record;
+  v_current_item_id                integer;
+  v_current_name                   text;
 BEGIN
 
   -- check that the item exists
@@ -1301,14 +1303,14 @@
     -- this is an absolute path so prepend a '/'
     -- loop over the absolute path
 
-    for v_rec in select i2.name, tree_level(i2.tree_sortkey) as tree_level
-                 from cr_items i1, cr_items i2
-                 where i2.parent_id <> 0
-                 and i1.item_id = get_path__item_id
-                 and i1.tree_sortkey between i2.tree_sortkey and tree_right(i2.tree_sortkey)
-                 order by tree_level
+    v_current_item_id := get_path__item_id;
+
+    while v_current_item_id <> 0
     LOOP
-      v_path := v_path || '/' || v_rec.name;
+      select parent_id, name into v_current_item_id, v_current_name from cr_items where item_id = v_current_item_id;
+      if FOUND then
+        v_path :=  '/' || v_current_name || v_path;
+      end if;
     end loop;
 
   end if;
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.1b3-5.9.1b4.sql'.
Fisheye: No comparison available.  Pass `N' to diff?