Hi!, I am having troubles with some upgrade scripts for postgres.
from 2.0.3 (tarball) to 2.1.0a2 (oacs-5-1)
I changed the apm_upgrade_logic in:
acs-authentication
apm-callback-procs.tcl
5.1.1 5.1.2 -> 5.1.1 5.1.2d1
dotlrn
apm-callback-procs.tcl
2.0.3 2.1.0 -> 2.0.3 2.1.0a2
fs-portlet:
upgrade-2.0.3-2.0.4.sql
The creation of a trigger did not work.
I fixed the trigger and committed the changes.
lars-blogger:
upgrade-2.0d2-2.0d3.sql
The creation of a trigger did not work.
I fixed the trigger and committed the changes.
workflow:
upgrade-1.2-2.0d1.sql
I reported the bug #2094
https://openacs.org/bugtracker/openacs/bug?bug%5fnumber=2094
file-storage:
upgrade-5.1.0d1-5.1.0d2.sql
The script did not work, i commented this line:
line 49
-- drop function file_storage__new_root_folder(integer);
This worked, but is ok?
upgrade-5.1.0a6-5.1.0a7.sql
I got this error:
CREATE FUNCTION
CREATE FUNCTION
psql:upgrade-5.1.0a6-5.1.0a7.sql:80: ERROR: invalid input syntax for integer: "Notas.2.xls"
CONTEXT: PL/pgSQL function "tmp_fs_name_duplicate" while casting return value to function's return type
PL/pgSQL function "inline_0" line 32 at select into variables
DROP FUNCTION
DROP FUNCTION
I commented this in bug #2092
Héctor.