Forum OpenACS Development: Re: Towards OpenACS 5.9
7: Re: Towards OpenACS 5.9 (response to 2)
Posted by Andrew Piskorski on 05/08/15 12:47 AM
This is partially due to my losing an argument with ArsDigita oh, what, 15 years ago? For whatever reason, the arsDigita folk were unwilling to use proper foreign key constraints in their Oracle data modelsReally? That seems weird and suprising. I don't remember hearing about that back then. I wonder what their reasons were, and if they made any sense.
12: Re: Towards OpenACS 5.9 (response to 7)
Posted by Don Baccus on 05/09/15 06:27 AM
Well, you probably don't remember hearing it because it was me, not you, proposing it.
The argument was that with proper RI operators, someone might enter the DB, delete a class of objects, and wipe out the whole contents.
Where by using "foreign key" without "on delete", manual attempts of this sort would be aborted by the db.
Now, as to why one might delete such things manually, at that time. aD's code was really horrible at cleaning itself up.