Forum OpenACS Q&A: Re: Project Manager 1.09b1 released

Collapse
11: Re: Project Manager 1.09b1 released (response to 10)
Posted by Rocael Hernández Rizzardini on 07/02/04 06:01 AM
ok, the error is in the last line of the upgrade file:

db-> update cr_items set parent_id = (select package_id from cr_folders where folder_id = item_id and label = 'Projects')
db-> where item_id = (select folder_id from cr_folders where label = 'Projects' and description = 'Project Repository');
ERROR:  relation "chid" does not exist
CONTEXT:  PL/pgSQL function "cr_items_tree_update_tr" line 28 at select into variables

any hints?

Collapse
13: Re: Project Manager 1.09b1 released (response to 11)
Posted by Rocael Hernández Rizzardini on 07/02/04 06:16 AM
ok, its an error on this pg func: cr_items_tree_update_tr, instead of chid should be child?  I tried to re-create this function but seems to have dependencies that don't allow me to drop it, anyone with suggestions?
Collapse
14: Re: Project Manager 1.09b1 released (response to 13)
Posted by Rocael Hernández Rizzardini on 07/02/04 06:29 AM
ok, dropping the trigger is what I needed ;)
then all the pm upgrades worked just fine!