Index: openacs-4/packages/acs-kernel/sql/postgresql/groups-body-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/groups-body-create.sql,v
diff -u -N -r1.20 -r1.21
--- openacs-4/packages/acs-kernel/sql/postgresql/groups-body-create.sql	18 Feb 2003 20:54:32 -0000	1.20
+++ openacs-4/packages/acs-kernel/sql/postgresql/groups-body-create.sql	13 Mar 2003 20:23:24 -0000	1.21
@@ -10,9 +10,6 @@
 -- TRIGGERS --
 --------------
 
-drop trigger membership_rels_in_tr on membership_rels;
-drop function membership_rels_in_tr ();
-
 -- The insert trigger was dummied up in groups-create.sql, so we just need
 -- to replace the trigger function, not create the trigger.
 
@@ -26,7 +23,10 @@
 -- this will be the right thing to do if the PG folks fix this problem or when
 -- we drop support of PG 7.2 and no longer need to declare these as type "opaque"
 
-create function membership_rels_in_tr () returns opaque as '
+drop trigger membership_rels_in_tr on membership_rels;
+drop function membership_rels_in_tr ();
+
+create or replace function membership_rels_in_tr () returns opaque as '
 declare
   v_object_id_one acs_rels.object_id_one%TYPE;
   v_object_id_two acs_rels.object_id_two%TYPE;
@@ -140,6 +140,9 @@
 create trigger membership_rels_del_tr before delete on membership_rels
 for each row execute procedure membership_rels_del_tr ();
 
+drop trigger composition_rels_in_tr on composition_rels;
+drop function composition_rels_in_tr ();
+
 create or replace function composition_rels_in_tr () returns opaque as '
 declare
   v_object_id_one acs_rels.object_id_one%TYPE;
@@ -755,7 +758,7 @@
 -- function new
 select define_function_args('acs_group__new','group_id,object_type;group,creation_date;now(),creation_user,creation_ip,email,url,group_name,join_policy,context_id');
 
-create or replace function acs_group__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,varchar,varchar,integer)
+create or replace function acs_group__new (integer,varchar,timestamptz,integer,varchar,varchar,varchar,varchar,varchar,integer)
 returns integer as '
 declare
   new__group_id              alias for $1;  -- default null