Forum OpenACS Development: Re: apm callbacks during uninstall?

Collapse
Posted by Don Baccus on
Now that PostgreSQL has implemented ALTER TABLE ADD CONSTRAINT etc we should pick a point in time in which we chose to upgrade the toolkit to make proper use of the ON DELETE CASCADE constraint modifier.

Life would be so much easier ... unfortunately Oracle doesn't  support the full set (ON DELETE SET NULL or ON DELETE SET DEFAULT or to some value) so we can't manage referential integrity fully in the way SQL expects oen to, but ON DELETE CASCADE's a good first step IMO.

Collapse
Posted by Jeff Davis on
Should we cascade the primary key constraints which reference acs_objects? The acs_object__delete() plpgsql call does things that simply cascading the delete from acs_objects would not do. Of course most of those things are further deletes which could be cascaded.

Almost none of the object type tables currently do this and I am not sure if it's a good idea or not.