Index: openacs-4/packages/calendar/www/admin/cal-item-permissions-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/admin/Attic/cal-item-permissions-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/calendar/www/admin/cal-item-permissions-postgresql.xql 5 Sep 2001 05:48:18 -0000 1.1 +++ openacs-4/packages/calendar/www/admin/cal-item-permissions-postgresql.xql 5 Sep 2001 13:44:56 -0000 1.2 @@ -28,7 +28,7 @@ - select unique(grantee_id) as party_id, + select distinct(grantee_id) as party_id, acs_object__name(grantee_id) as name from acs_permissions where object_id = :cal_item_id Index: openacs-4/packages/calendar/www/admin/cal-item-permissions.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/admin/Attic/cal-item-permissions.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/calendar/www/admin/cal-item-permissions.xql 5 Sep 2001 05:48:18 -0000 1.1 +++ openacs-4/packages/calendar/www/admin/cal-item-permissions.xql 5 Sep 2001 13:44:56 -0000 1.2 @@ -4,7 +4,7 @@ - select unique(child_privilege) as privilege + select distinct(child_privilege) as privilege from acs_privilege_hierarchy where child_privilege like 'cal_item%' Index: openacs-4/packages/calendar/www/admin/calendar-permissions.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/admin/Attic/calendar-permissions.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/calendar/www/admin/calendar-permissions.xql 5 Sep 2001 05:48:18 -0000 1.1 +++ openacs-4/packages/calendar/www/admin/calendar-permissions.xql 5 Sep 2001 13:44:56 -0000 1.2 @@ -4,7 +4,7 @@ - select unique(child_privilege) as privilege + select distinct(child_privilege) as privilege from acs_privilege_hierarchy where child_privilege like 'calendar%' Index: openacs-4/packages/calendar/www/admin/calendar-preferences-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/admin/Attic/calendar-preferences-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/calendar/www/admin/calendar-preferences-postgresql.xql 5 Sep 2001 05:48:18 -0000 1.1 +++ openacs-4/packages/calendar/www/admin/calendar-preferences-postgresql.xql 5 Sep 2001 13:44:56 -0000 1.2 @@ -17,7 +17,7 @@ - select unique(object_id) as calendar_id, + select distinct(object_id) as calendar_id, calendar__name(object_id) as calendar_name, calendar__show_p(object_id, :party_id) as show_p from acs_object_party_privilege_map Index: openacs-4/packages/calendar/www/admin/one-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/admin/Attic/one-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/calendar/www/admin/one-postgresql.xql 5 Sep 2001 05:48:18 -0000 1.1 +++ openacs-4/packages/calendar/www/admin/one-postgresql.xql 5 Sep 2001 13:44:56 -0000 1.2 @@ -6,7 +6,7 @@ - select unique(grantee_id) as party_id, + select distinct(grantee_id) as party_id, acs_object__name(grantee_id) as name from acs_permissions where object_id = :calendar_id