Index: openacs-4/packages/contacts/www/relationship-bulk-add-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/www/relationship-bulk-add-postgresql.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/contacts/www/relationship-bulk-add-postgresql.xql 20 Apr 2006 14:09:07 -0000 1.2 +++ openacs-4/packages/contacts/www/relationship-bulk-add-postgresql.xql 2 May 2006 12:13:10 -0000 1.3 @@ -69,60 +69,4 @@ - - -select acs_object__delete(rel_id) - from acs_rels - where ( object_id_one = :party_id or object_id_two = :party_id ) - and rel_type = :rel_type - - - - - -select rel_id - from acs_rels - where rel_type = :rel_type - and ((:switch_roles_p = 0 and object_id_one = :object_id_one and object_id_two = :object_id_two) - or (:switch_roles_p = 1 and object_id_one = :object_id_two and object_id_two = :object_id_one)) - - - - - -select acs_rel__new ( - :rel_id, - :rel_type, - :object_id_one, - :object_id_two, - :context_id, - :creation_user, - :creation_ip - ) - - - - - -select acs_rel__new ( - :rel_id, - :rel_type, - :object_id_two, - :object_id_one, - :context_id, - :creation_user, - :creation_ip - ) - - - - - -insert into contact_rels - (rel_id) -values - (:rel_id) - - -