Forum OpenACS Q&A: Re: Categories 1.0d5 released

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.