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.2.2 -r1.9.2.3
--- openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql	15 Feb 2003 03:25:02 -0000	1.9.2.2
+++ openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql	2 Mar 2003 22:33:34 -0000	1.9.2.3
@@ -269,7 +269,7 @@
 -- PARTY PACKAGE --
 -------------------
 
-create function party__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,integer)
+create function party__new (integer,varchar,timestamptz,integer,varchar,varchar,varchar,integer)
 returns integer as '
 declare
   new__party_id               alias for $1;  -- default null  
@@ -391,7 +391,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 with time zone,integer,varchar,varchar,varchar,varchar,varchar,integer)
+create function person__new (integer,varchar,timestamptz,integer,varchar,varchar,varchar,varchar,varchar,integer)
 returns integer as '
 declare
   new__person_id              alias for $1;  -- default null  
@@ -503,9 +503,9 @@
 	priv_email		integer default 5 not null,
 	email_verified_p	boolean default 't',
 	email_bouncing_p	boolean default 'f' not null,
-	no_alerts_until		timestamp,
-	last_visit		timestamp,
-	second_to_last_visit	timestamp,
+	no_alerts_until		timestamptz,
+	last_visit		timestamptz,
+	second_to_last_visit	timestamptz,
 	n_sessions		integer default 1 not null,
 	password_question	varchar(1000),
 	password_answer		varchar(1000)
@@ -628,7 +628,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 with time zone,integer,varchar,varchar,varchar,varchar,varchar,char,char,varchar,varchar,varchar,boolean,integer)
+create function acs_user__new (integer,varchar,timestamptz,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