Fisheye: Tag 1.2.32.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-subsite/www/admin/rel-segments/elements-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1.32.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-subsite/www/admin/rel-segments/elements-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/acs-subsite/www/admin/rel-segments/elements.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/rel-segments/elements.tcl,v
diff -u -r1.9 -r1.9.2.1
--- openacs-4/packages/acs-subsite/www/admin/rel-segments/elements.tcl	7 Jun 2018 17:41:01 -0000	1.9
+++ openacs-4/packages/acs-subsite/www/admin/rel-segments/elements.tcl	2 Jan 2020 15:43:32 -0000	1.9.2.1
@@ -24,7 +24,16 @@
     }
 }
 
-db_1row select_segment_info {}
+db_1row select_segment_info {
+    select s.segment_name,
+           s.group_id,
+           (select pretty_plural
+            from acs_rel_roles
+            where role = r.role_two) as role_pretty_plural
+      from rel_segments s, acs_rel_types r
+     where s.segment_id = :segment_id
+       and s.rel_type = r.rel_type
+}
 
 # The role pretty names can be message catalog keys that need
 # to be localized before they are displayed