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.4 -r1.5
--- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql	21 Dec 2002 22:30:51 -0000	1.4
+++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql	17 May 2003 09:52:12 -0000	1.5
@@ -8,7 +8,7 @@
 
 -- Package Implementations ---------------------------------------------
 
-create function acs_mail_gc_object__new (integer,varchar,timestamp with time zone,integer,varchar,integer)
+create function acs_mail_gc_object__new (integer,varchar,timestamptz,integer,varchar,integer)
 returns integer as '
 declare
     p_gc_object_id  alias for $1;    -- default null
@@ -51,7 +51,7 @@
 -- first create a CR item.
 -- then call acs_mail_body__new with the CR item's item_id
 
-create function acs_mail_body__new (integer,integer,integer,timestamp with time zone,varchar,varchar,text,text,text,integer,varchar,date,integer,varchar,integer)
+create function acs_mail_body__new (integer,integer,integer,timestamptz,varchar,varchar,text,text,text,integer,varchar,date,integer,varchar,integer)
 returns integer as ' 
 declare
 	p_body_id			alias for $1;    -- default null
@@ -136,8 +136,7 @@
 end;
 ' language 'plpgsql';
 
-create function acs_mail_body__clone (integer,integer,varchar,timestamp with time zone,
-integer,varchar,integer) 
+create function acs_mail_body__clone (integer,integer,varchar,timestamptz,integer,varchar,integer) 
 returns integer as '
 declare 
 	p_old_body_id       alias for $1;
@@ -150,7 +149,7 @@
     v_object_id         integer;
     v_body_reply_to		integer;
     v_body_from         integer;
-    v_body_date         timestamp;
+    v_body_date         timestamptz;
     v_header_message_id varchar;
     v_header_reply_to   varchar;
     v_header_subject    text;
@@ -205,7 +204,7 @@
 ----
 --create or replace package body acs_mail_multipart
 create function acs_mail_multipart__new (integer,varchar,varchar,
-timestamp,integer,varchar,integer) 
+timestamptz,integer,varchar,integer) 
 returns integer as '
 declare
 	p_multipart_id		alias for $1;    -- default null,
@@ -296,7 +295,7 @@
 --end acs_mail_multipart;
 
 --create or replace package body acs_mail_link__
-create function acs_mail_link__new (integer,integer,integer,timestamp with time zone,integer,varchar,varchar)
+create function acs_mail_link__new (integer,integer,integer,timestamptz,integer,varchar,varchar)
 returns integer as '
 declare
 	p_mail_link_id			alias for $1;    -- default null
