Index: openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql,v diff -u -r1.9 -r1.9.2.1 --- openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql 13 Mar 2002 22:50:53 -0000 1.9 +++ openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql 21 Jan 2003 13:46:20 -0000 1.9.2.1 @@ -301,7 +301,7 @@ -- create or replace package body party -- function new -create function party__new (integer,varchar,timestamp,integer,varchar,varchar,varchar,integer) +create function party__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,integer) returns integer as ' declare new__party_id alias for $1; -- default null @@ -430,7 +430,7 @@ -- create or replace package body person -- function new select define_function_args('person__new','person_id,object_type;person,creation_date;now(),creation_user,creation_ip,email,url,first_names,last_name,context_id'); -create function person__new (integer,varchar,timestamp,integer,varchar,varchar,varchar,varchar,varchar,integer) +create function person__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,varchar,varchar,integer) returns integer as ' declare new__person_id alias for $1; -- default null @@ -667,7 +667,7 @@ select define_function_args('user__new','user_id,object_type;user,creation_date;now(),creation_user,creation_ip,email,url,first_names,last_name,password,salt,password_question,password_answer,screen_name,email_verified_p;t,context_id'); -create function acs_user__new (integer,varchar,timestamp,integer,varchar,varchar,varchar,varchar,varchar,char,char,varchar,varchar,varchar,boolean,integer) +create function acs_user__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,varchar,varchar,char,char,varchar,varchar,varchar,boolean,integer) returns integer as ' declare new__user_id alias for $1; -- default null