Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b1-5.0.0b2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b1-5.0.0b2.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b1-5.0.0b2.sql 11 Dec 2003 21:39:52 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b1-5.0.0b2.sql 4 Apr 2018 04:18:44 -0000 1.3 @@ -114,7 +114,7 @@ drop trigger acs_objects_insert_tr on acs_objects; drop function acs_objects_insert_tr(); -- --- dont want to mess up modification dates. +-- don't want to mess up modification dates. -- drop trigger acs_objects_last_mod_update_tr on acs_objects; drop function acs_objects_last_mod_update_tr(); Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d8-5.2.0d9.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d8-5.2.0d9.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d8-5.2.0d9.sql 6 Mar 2005 19:09:41 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d8-5.2.0d9.sql 4 Apr 2018 04:18:44 -0000 1.2 @@ -1,4 +1,4 @@ --- on pg8 the get_func_drop_command is not found since it wont coerce proname to varchar +-- on pg8 the get_func_drop_command is not found since it won't coerce proname to varchar create or replace function drop_package (varchar) returns varchar as ' declare package_name alias for $1; Index: openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql,v diff -u -r1.20 -r1.21 --- openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql 7 Aug 2017 23:48:11 -0000 1.20 +++ openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql 4 Apr 2018 04:18:44 -0000 1.21 @@ -107,7 +107,7 @@ last_child_post = current_timestamp where message_id = forums_message__root_message_id(v_message_id); else - -- dont update last_poster, last_child_post when not approved + -- don't update last_poster, last_child_post when not approved update forums_messages set reply_count = reply_count + 1 where message_id = forums_message__root_message_id(v_message_id); Index: openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.2d1-1.2d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.2d1-1.2d2.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.2d1-1.2d2.sql 12 Aug 2013 09:34:31 -0000 1.2 +++ openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.2d1-1.2d2.sql 4 Apr 2018 04:18:44 -0000 1.3 @@ -148,7 +148,7 @@ last_child_post = current_timestamp where message_id = forums_message__root_message_id(v_message_id); else - -- dont update last_poster, last_child_post when not approved + -- don't update last_poster, last_child_post when not approved update forums_messages set reply_count = reply_count + 1 where message_id = forums_message__root_message_id(v_message_id);