Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql	21 Dec 2002 22:32:31 -0000	1.6
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql	17 May 2003 09:43:09 -0000	1.7
@@ -167,8 +167,8 @@
 			 references cr_items
 			 constraint cr_release_periods_pk
 			 primary key,
-	start_when	 timestamp default now(),
-	end_when	 timestamp default now() + interval ''20 years''
+	start_when	 timestamptz default current_timestamp,
+	end_when	 timestamptz default current_timestamp + interval ''20 years''
       )'';
 
   end if;
@@ -179,7 +179,7 @@
 
     execute ''
       create table cr_scheduled_release_log (
-	exec_date        timestamp default now() not null,
+	exec_date        timestamptz default current_timestamp not null,
 	items_released   integer not null,
 	items_expired    integer not null,
 	err_num          integer,
@@ -195,7 +195,7 @@
     execute ''
       create table cr_scheduled_release_job (
         job_id     integer,
-        last_exec  timestamp
+        last_exec  timestamptz
       )'';
 
     execute ''