Index: openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql,v diff -u -r1.23 -r1.23.2.1 --- openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql 28 Jun 2018 09:10:14 -0000 1.23 +++ openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql 11 Dec 2019 16:37:22 -0000 1.23.2.1 @@ -9,11 +9,11 @@ - + select person__delete(:person_id); - + @@ -37,20 +37,20 @@ (t1.object_type = 'group' or t1.object_type = 'person') - + t1.object_type = :start_with - + - + - select types.pretty_name, - types.object_type, - types.tree_level, + select types.pretty_name, + types.object_type, + types.tree_level, types.indent, case when valid_types.object_type = null then 0 else 1 end as valid_p from (select t2.pretty_name, @@ -63,12 +63,12 @@ where t2.tree_sortkey between t1.tree_sortkey and tree_right(t1.tree_sortkey) and $start_with_clause ) types left outer join - (select object_type + (select object_type from rel_types_valid_obj_two_types where rel_type = :rel_type ) valid_types using (object_type) order by types.tree_sortkey - +