Index: openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql,v
diff -u -r1.18 -r1.19
--- openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql	9 Dec 2001 04:21:58 -0000	1.18
+++ openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql	11 Jul 2002 16:15:39 -0000	1.19
@@ -420,13 +420,13 @@
 BEGIN
 
  	FOR c_bookmark_id_tree IN 
-	    select bookmark_id,
+	    select bm.bookmark_id,
 	    (select case when count(*)=0 then 1 else 0 end from 
 	    bm_bookmarks where parent_id = bm.bookmark_id) as is_leaf_p
 	    from bm_bookmarks bm, bm_bookmarks bm2
             where bm2.bookmark_id = p_bookmark_id
 	      and bm.tree_sortkey between bm2.tree_sortkey and tree_right(bm2.tree_sortkey)
-            order by tree_level(tree_sortkey) desc, is_leaf_p desc, tree_sortkey
+            order by tree_level(bm.tree_sortkey) desc, is_leaf_p desc, bm.tree_sortkey
  	LOOP
 
             -- DRB: This query is insane in both its PG and Oracle versions but I do not