Hello,
I am still phased out. But maybe this would help.
http://cvs.openacs.org/cvs/*checkout*/openacs-4/contrib/packages/bcms/sql/postgresql/bcms-create.sql?rev=1.9
I have a modified content_item__get_path for pg (last part of the file). Because of this 2 things:
1. Its a bit slow.
2. Hammering it real hard makes my pg go up. I have to turn restart postmaster.
Those plsql are not in bugtracker patches because:
1. Its not fully tested.
2. Some changes the behaviour, I have still no time to hunt down code that relies on the old incorrect behaviour.
Anyway not much help here, also good understanding of the topic. But if it helps, please pick it up. Thanks.
