Index: openacs-4/packages/categories/sql/postgresql/categories-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/categories-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/categories/sql/postgresql/categories-drop.sql	19 May 2003 13:09:56 -0000	1.1
+++ openacs-4/packages/categories/sql/postgresql/categories-drop.sql	29 Sep 2003 04:21:53 -0000	1.2
@@ -35,26 +35,26 @@
 end;
 
 drop function category_tree__new (integer,varchar,varchar,varchar,
-        char,timestamp,integer,varchar,integer);
+        char,timestamp with time zone,integer,varchar,integer);
 drop function category_tree__new_translation (integer,varchar,varchar,
-        varchar,timestamp,integer,varchar);
+        varchar,timestamp with time zone,integer,varchar);
 drop function category_tree__del (integer);
 drop function category_tree__edit (integer,varchar,varchar,varchar,
-        char,timestamp,integer,varchar);
+        char,timestamp with time zone,integer,varchar);
 drop function category_tree__copy (integer,integer,integer,varchar);
 drop function category_tree__map (integer,integer,integer);
 drop function category_tree__unmap (integer,integer);
 drop function category_tree__check_nested_ind (integer);
 -- drop function category_tree__index_children (integer,integer);
 drop function category__new (integer,integer,varchar,varchar,varchar,
-        integer,char,timestamp,integer,varchar);
+        integer,char,timestamp with time zone,integer,varchar);
 drop function category__new_translation (integer,varchar,varchar,varchar,
-        timestamp,integer,varchar);
+        timestamp with time zone,integer,varchar);
 drop function category__phase_out (integer);
 drop function category__phase_in (integer);
 drop function category__del (integer);
 drop function category__edit (integer,varchar,varchar,varchar,
-        timestamp,integer,varchar);
+        timestamp with time zone,integer,varchar);
 drop function category__change_parent (integer,integer,integer);
 drop function category__name (integer);
 
Index: openacs-4/packages/categories/sql/postgresql/category-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/category-package.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/categories/sql/postgresql/category-package.sql	19 May 2003 13:09:56 -0000	1.1
+++ openacs-4/packages/categories/sql/postgresql/category-package.sql	29 Sep 2003 04:21:53 -0000	1.2
@@ -13,7 +13,7 @@
     varchar,   -- description
     integer,   -- parent_id
     char,      -- deprecated_p
-    timestamp, -- creation_date
+    timestamp with time zone, -- creation_date
     integer,   -- creation_user
     varchar    -- creation_ip
 )
@@ -93,7 +93,7 @@
     varchar,   -- locale
     varchar,   -- name
     varchar,   -- description
-    timestamp, -- modifying_date
+    timestamp with time zone, -- modifying_date
     integer,   -- modifying_user
     varchar    -- modifying_ip
 )
@@ -204,7 +204,7 @@
     varchar,   -- locale
     varchar,   -- name
     varchar,   -- description
-    timestamp, -- modifying_date
+    timestamp with time zone, -- modifying_date
     integer,   -- modifying_user
     varchar    -- modifying_ip
 )
Index: openacs-4/packages/categories/sql/postgresql/category-tree-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/category-tree-package.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/categories/sql/postgresql/category-tree-package.sql	19 May 2003 13:09:56 -0000	1.1
+++ openacs-4/packages/categories/sql/postgresql/category-tree-package.sql	29 Sep 2003 04:21:53 -0000	1.2
@@ -12,7 +12,7 @@
     varchar, -- tree_name
     varchar, -- description
     char,    -- site_wide_p
-    timestamp, -- creation_date
+    timestamp with time zone, -- creation_date
     integer, -- creation_user
     varchar, -- creation_ip
     integer  -- context_id
@@ -75,7 +75,7 @@
     varchar,   -- locale
     varchar,   -- tree_name
     varchar,   -- description
-    timestamp, -- modifying_date
+    timestamp with time zone, -- modifying_date
     integer,   -- modifying_user
     varchar    -- modifying_ip
 )
@@ -138,7 +138,7 @@
     varchar,   -- tree_name
     varchar,   -- description
     char,      -- site_wide_p
-    timestamp, -- modifying_date
+    timestamp with time zone, -- modifying_date
     integer,   -- modifying_user
     varchar    -- modifying_ip
 )