Index: openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql	17 May 2003 09:52:12 -0000	1.5
+++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql	11 Dec 2003 21:39:54 -0000	1.6
@@ -120,7 +120,7 @@
 end;
 ' language 'plpgsql';
 
-create function acs_mail_body__body_p(integer) 
+create or replace function acs_mail_body__body_p(integer) 
 returns boolean as '
 	p_object_id		alias for $1;
     v_check_body_id integer;
@@ -134,7 +134,7 @@
          return ''f'';
      end if;
 end;
-' language 'plpgsql';
+' language 'plpgsql' stable;
 
 create function acs_mail_body__clone (integer,integer,varchar,timestamptz,integer,varchar,integer) 
 returns integer as '
@@ -245,7 +245,7 @@
 end;
 ' language 'plpgsql';
 
-create function acs_mail_multipart__multipart_p (integer)
+create or replace function acs_mail_multipart__multipart_p (integer)
 returns boolean as '
 declare
 	p_object_id				alias for $1;
@@ -261,7 +261,7 @@
         return ''f'';
     end if;
 end;
-' language 'plpgsql';
+' language 'plpgsql' stable;
 
  -- Add content at a specific index.  If the sequence number is null,
  -- below one, or higher than the highest item already available,
@@ -336,7 +336,7 @@
 end;
 ' language 'plpgsql';
 
-create function acs_mail_link__link_p (integer)
+create or replace function acs_mail_link__link_p (integer)
 returns boolean as '
 declare
 	p_object_id				alias for $1;
@@ -352,7 +352,7 @@
         return ''f'';
     end if;
 end;
-' language 'plpgsql';
+' language 'plpgsql' stable;
 
 --end acs_mail_link;