Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql 28 Apr 2001 19:58:39 -0000 1.5 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-schedule.sql 13 May 2001 01:55:59 -0000 1.6 @@ -95,6 +95,10 @@ exec__err_msg ); + -- Table was growing without bound (OpenACS DanW) + delete from cr_scheduled_release_log + where exec_date < now() - ''4 week''::interval; + -- Reset the last time of execution to start of processing update cr_scheduled_release_job set last_exec = exec__this_exec; @@ -106,6 +110,9 @@ -- show errors -- initialize the scheduled publication job + +-- Job scheduling has been moved to aolserver for both the oracle and +-- postgresql versions. DanW create function inline_1 () returns integer as '