Forum OpenACS Q&A: Categories 1.0d5 released

Collapse
1: Categories 1.0d5 released
Posted by Jade Rubick on 11/18/04 11:40 PM
Please note this caveat: if you are upgrading, the first time you install it, it may fail, because the upgrade script tries to drop tables and functions that don't exist.

If you try a second time it should work.

This upgrade is also necessary for project-manager, which I'm also bumping a version to reflect this dependency.

Collapse
2: Re: Categories 1.0d5 released (response to 1)
Posted by Malte Sussdorff on 11/19/04 09:41 AM
As this happens quite often, is there a possibility to conditionaly drop (as in "drop or do nothing") a table? Furthermore, for functions, why dont you use "create or replace" ?
Collapse
3: Re: Categories 1.0d5 released (response to 2)
Posted by Jade Rubick on 11/19/04 06:47 PM
I would love to have a way to conditionally drop a table. Perhaps it could be done in PL/SQL?

This would be a nice addition to the toolkit, and would help improve the robustness of upgrades.

I didn't write the upgrade script. I use create or replace myself.