Index: openacs-4/packages/forums/sql/postgresql/upgrade-0.1d-0.2d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/Attic/upgrade-0.1d-0.2d.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/forums/sql/postgresql/upgrade-0.1d-0.2d.sql	30 Nov 2002 17:35:03 -0000	1.2
+++ openacs-4/packages/forums/sql/postgresql/upgrade-0.1d-0.2d.sql	17 May 2003 10:42:08 -0000	1.3
@@ -1,10 +1,10 @@
-alter table forums_forums add column last_post timestamp;
-alter table forums_messages add column last_child_post timestamp;
+alter table forums_forums add column last_post timestamptz;
+alter table forums_messages add column last_child_post timestamptz;
 
 create or replace function t () returns integer as '
 declare
   v_record record;
-  v_timestamp timestamp; 
+  v_timestamp timestamptz; 
 begin
 
   for v_record in select forum_id
@@ -68,7 +68,7 @@
     from forums_forums
     where enabled_p = 't';
 
-create or replace function forums_message__new (integer,varchar,integer,varchar,text,char,integer,timestamp,varchar,integer,timestamp,integer,varchar,integer)
+create or replace function forums_message__new (integer,varchar,integer,varchar,text,char,integer,timestamptz,varchar,integer,timestamptz,integer,varchar,integer)
 returns integer as '
 declare
     p_message_id                    alias for $1;
@@ -137,7 +137,7 @@
 end;
 ' language 'plpgsql';
 
-create or replace function forums_forum__new (integer,varchar,varchar,varchar,varchar,varchar,integer,timestamp,integer,varchar,integer)
+create or replace function forums_forum__new (integer,varchar,varchar,varchar,varchar,varchar,integer,timestamptz,integer,varchar,integer)
 returns integer as '
 declare
     p_forum_id                      alias for $1;