Index: openacs-4/packages/acs-subsite/www/admin/users/new-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/users/new-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/users/new-postgresql.xql	15 May 2001 16:59:01 -0000	1.1
+++ openacs-4/packages/acs-subsite/www/admin/users/new-postgresql.xql	3 Sep 2001 20:51:38 -0000	1.2
@@ -5,16 +5,16 @@
 
 <fullquery name="rel_type_info">      
       <querytext>
-      FIX ME CONNECT BY
 
     select object_type as ancestor_rel_type
       from acs_object_types
      where supertype = 'relationship'
        and object_type in (
-               select object_type from acs_object_types
-               start with object_type = :add_with_rel_type
-               connect by object_type = prior supertype
-           )
+               select t1.object_type
+	         from acs_object_types t1, acs_object_types t2
+		where t2.tree_sortkey like (t1.tree_sortkey || '%')
+		  and t1.object_type = :add_with_rel_type
+	   )
 
       </querytext>
 </fullquery>