Index: openacs-4/packages/dotlrn/sql/postgresql/communities-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/communities-package-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/dotlrn/sql/postgresql/communities-package-create.sql	9 Aug 2002 18:39:25 -0000	1.6
+++ openacs-4/packages/dotlrn/sql/postgresql/communities-package-create.sql	29 May 2003 18:05:00 -0000	1.7
@@ -55,7 +55,7 @@
 END;
 ' language 'plpgsql';
 
-create function dotlrn_community_type__new (varchar,varchar,varchar,varchar,varchar,integer,timestamp,integer,varchar,integer)
+create function dotlrn_community_type__new (varchar,varchar,varchar,varchar,varchar,integer,timestamptz,integer,varchar,integer)
 returns varchar as '
 DECLARE
         p_community_type                        alias for $1;
@@ -86,9 +86,9 @@
             p_community_type,
             p_community_type,
 	    v_parent_object_type,
-            v_unique_name,
-            v_unique_name,
-            v_unique_name,
+            cast(v_unique_name as varchar),
+            cast(v_unique_name as varchar),
+            cast(v_unique_name as varchar),
 	    ''f'',
 	    null,
             ''acs_group.name''
@@ -158,7 +158,7 @@
 
 select define_function_args('dotlrn_community__new','community_id,parent_community_id,community_type,community_key,pretty_name,description,archived_p;f,portal_id,non_member_portal_id,package_id,join_policy,creation_date,creation_user,creation_ip,context_id');
 
-create function dotlrn_community__new(integer,integer,varchar,varchar,varchar,varchar,varchar,integer,integer,integer,varchar,timestamp,integer,varchar,integer)
+create function dotlrn_community__new(integer,integer,varchar,varchar,varchar,varchar,varchar,integer,integer,integer,varchar,timestamptz,integer,varchar,integer)
 returns integer as '
 DECLARE
         p_community_id                  alias for $1;
