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 -N -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;