Forum OpenACS Q&A: Re: Error deleting a folder in file-storage

Collapse
3: Re: Error deleting a folder in file-storage (response to 1)
Posted by Nima Mazloumi on 01/31/08 11:11 AM
ALTER TABLE site_node_object_mappings DROP CONSTRAINT snom_object_id_fk;

ALTER TABLE site_node_object_mappings ADD CONSTRAINT snom_object_id_fk FOREIGN KEY (object_id) REFERENCES acs_objects (object_id) ON UPDATE CASCADE ON DELETE CASCADE;

Collapse
5: Re: Error deleting a folder in file-storage (response to 3)
Posted by Don Baccus on 02/04/08 10:41 AM
Please write up an upgrade script if you have time, and test it, Nima.

And edit the initial install SQL script, too, if you do! :)

The same ALTER TABLEs should work on oracle EXCEPT that Oracle does not support ON UPDATE CASCADE, only ON DELETE CASCADE.

If you can edit initial install and upgrade scripts for Oracle, too, and afterwards e-mail honchos I'm sure you can get daveb to test it ...

or me ...