Index: openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-create.sql,v diff -u -r1.16.2.1 -r1.16.2.2 --- openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-create.sql 1 Jul 2016 04:44:17 -0000 1.16.2.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-create.sql 31 Aug 2016 18:57:41 -0000 1.16.2.2 @@ -185,13 +185,10 @@ -- Helper functions to maintain the materialized party_approved_member_map. --- --- Create an "identity relationship" --- -select acs_object__new(-10, 'relationship') from dual; -insert into acs_rels (rel_id, rel_type, object_id_one, object_id_two) values (-10, 'relationship', 0, 0); + + select define_function_args('party_approved_member__add_one','party_id,member_id,rel_id'); -- @@ -333,8 +330,8 @@ END; $$ LANGUAGE plpgsql; -create trigger parties_in_tr after insert on parties -for each row execute procedure parties_in_tr (); + create trigger parties_in_tr after insert on parties + for each row execute procedure parties_in_tr (); CREATE OR REPLACE FUNCTION parties_del_tr () RETURNS trigger AS $$ BEGIN