Index: openacs-4/packages/contacts/lib/contact-relationships-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/lib/contact-relationships-postgresql.xql,v
diff -u -N -r1.12 -r1.13
--- openacs-4/packages/contacts/lib/contact-relationships-postgresql.xql	22 Aug 2006 16:27:12 -0000	1.12
+++ openacs-4/packages/contacts/lib/contact-relationships-postgresql.xql	8 Sep 2006 13:49:54 -0000	1.13
@@ -3,7 +3,7 @@
 
 <fullquery name="get_relationships">
       <querytext>
-select rel_id, other_party_id, role_singular, rel_type, creation_date
+select rel_id, other_party_id, role, role_singular, rel_type, creation_date
   from ( select object_id_two as other_party_id,
                 role_two as role,
                 pretty_name as role_singular,