Forum OpenACS Development: Re: ]project-open[ new Filestorage - acs_object__delete throws acs_permissions_on_what_id_fk

Using "on delete cascade" on the permissions table is not a recent change, but was introduced to OpenACS 14 years ago (2005, [1]).

-gn

[1] https://github.com/openacs/openacs-core/blame/2153b958443b2b1f296fa5bf434c338146a38e8f/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql#L404

The current ]po[ default database has been created in 2004 😊, I believe and since upgraded to the respective OpenACS and ]po[ version.

Frank

If you upgrade acs-core to 5.9.1, these constraints are added.