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.3 -r1.4 --- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql 13 Aug 2001 17:54:46 -0000 1.3 +++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-packages-create.sql 21 Dec 2002 22:30:51 -0000 1.4 @@ -8,7 +8,7 @@ -- Package Implementations --------------------------------------------- -create function acs_mail_gc_object__new (integer,varchar,timestamp,integer,varchar,integer) +create function acs_mail_gc_object__new (integer,varchar,timestamp with time zone,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,varchar,varchar,text,text,text,integer,varchar,date,integer,varchar,integer) +create function acs_mail_body__new (integer,integer,integer,timestamp with time zone,varchar,varchar,text,text,text,integer,varchar,date,integer,varchar,integer) returns integer as ' declare p_body_id alias for $1; -- default null @@ -136,7 +136,7 @@ end; ' language 'plpgsql'; -create function acs_mail_body__clone (integer,integer,varchar,timestamp, +create function acs_mail_body__clone (integer,integer,varchar,timestamp with time zone, integer,varchar,integer) returns integer as ' declare @@ -296,7 +296,7 @@ --end acs_mail_multipart; --create or replace package body acs_mail_link__ -create function acs_mail_link__new (integer,integer,integer,timestamp,integer,varchar,varchar) +create function acs_mail_link__new (integer,integer,integer,timestamp with time zone,integer,varchar,varchar) returns integer as ' declare p_mail_link_id alias for $1; -- default null