Forum OpenACS Development: 'content_revision__del' not removing acs_permissions
just noticed that the latest version of 'content_revision__del' deployed w/ upgrade-5.9.0d2-5.9.0d3.sql does not remove permissions.
Earlier versions did, e.g. upgrade-5.1.4d4-5.1.4d5.sql:
raise NOTICE ''Deleting associated permissions...'';
-- 5) delete associated permissions
delete from acs_permissions
where object_id = delete__item_id;
However, I do not want to exclude the possibility that the error I ran into is somehow specific to ]project-open[ ...
the 'delete cascade' constraint of the acs_permissions table is indeed missing.
Among other techniques I used FishEye  to find the related update script for the change you referred me to, but I wasn't able to find it.