Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql,v diff -u -r1.46.2.2 -r1.46.2.3 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql 26 Nov 2005 21:22:53 -0000 1.46.2.2 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql 29 Dec 2005 01:24:02 -0000 1.46.2.3 @@ -183,8 +183,8 @@ v_context_id := new__context_id; end if; - -- parent_id = 0 means that this is a mount point - if new__parent_id != 0 and + -- parent_id = security_context_root means that this is a mount point + if new__parent_id != -4 and content_folder__is_folder(new__parent_id) and content_folder__is_registered(new__parent_id,''content_folder'',''f'') = ''f'' then @@ -699,10 +699,10 @@ v_parent_id := v_rec.parent_id; exit when v_parent_id = is_sub_folder__folder_id; -- we did not find the folder, reset v_parent_id - v_parent_id := 0; + v_parent_id := -4; end LOOP; - if v_parent_id != 0 then + if v_parent_id != -4 then v_sub_folder_p := ''t''; end if; @@ -971,7 +971,7 @@ v_is_root boolean; begin - select parent_id = 0 into v_is_root + select parent_id = -4 into v_is_root from cr_items where item_id = is_root__folder_id; return v_is_root;