Forum OpenACS Development: Re: Towards OpenACS 5.9
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.
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.