Forum OpenACS Development: acs_privilege_descendant_map created as a table

packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d20-5.10.0d21.sql drops the acs_privilege_descendant_map table and related functions/triggers. Then recreates it as a view based on a recursive query.

packages/acs-kernel/sql/postgresql/acs-permissions-create.sql is still creating the table and related functions/triggers.

Also the column names are different between the table and the view--privilege,descendant vs parent,child.

The workaround it to manually run the upgrade-5.10.0d20-5.10.0d21.sql script after creating a new site.

I tried to submit this in the bug tracker, but got an error on submission.

Posted by Gustaf Neumann on
Dear Keith,

many thanks for the report. These are clearly two bugs.

The bug of the bug-tracker was introduced by marking a proc deprecated and immediately move these to tcl/deprecated-procs.tcl. When OpenACS is configured with WithDeprecatedCode set to 0 (which is the case on, then this file is not loaded... which broke the bug-tracker package (which is not on the list of fully maintained packages).

The bug tracker is already fixes, sorry for the inconveniences. I will look at acs_privilege_descendant_map the next days.

all the best
PS: i've also updated the coding guidelines to hint the drawback of eager moving procs the long-deprecated procs.

Posted by Gustaf Neumann on
The commit [1] has removes the obsolete tables/triggers/maintenance code from fresh installations. The change also contains an update script such that newer installations (still created with the obsolete tables) are corrected as well.

All the best, and thanks for noting.