Bad news!
Running OpenACS 5.7.0 on Naviserver and PostgreSQL 8.4.4 the upgrade scripts still throw the errors.
COMMIT
Failed to install Kernel, version 5.8.1. The following error was generated:
psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:10: ERROR: unterminated dollar-quoted string at or near "$$ DECLARE v_rec record;" at character 87 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:11: ERROR: syntax error at or near "v_drop_cmd" at character 8 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:12: ERROR: syntax error at or near "v_pkg_name" at character 8 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:14: ERROR: syntax error at or near "raise" at character 15 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:15: ERROR: syntax error at or near "v_pkg_name" at character 9 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:22: ERROR: syntax error at or near "for" at character 9 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:23: ERROR: syntax error at or near "v_drop_cmd" at character 13 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:24: ERROR: prepared statement "v_drop_cmd" does not exist psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:25: ERROR: syntax error at or near "loop" at character 13 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:28: ERROR: syntax error at or near "if" at character 9 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:30: ERROR: syntax error at or near "else" at character 9 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:31: ERROR: syntax error at or near "if" at character 13 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:33: ERROR: syntax error at or near "return" at character 9 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:35: WARNING: there is no transaction in progress psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:36: ERROR: unterminated dollar-quoted string at or near "$$ LANGUAGE plpgsql;" at character 1 psql:/var/lib/aolserver/taxonomy/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.0d1-5.8.0d2.sql:48: ERROR: unterminated dollar-quoted string at or near "$$ DECLARE nargs integer default 0;" at character 103