I have come to the conclusion that this is not an issue with truncation because:
1) OpenACS4.6 and 4.6.3 are both compatible with PostgreSQL 7.2.1
2) If the function, table or view names were truncated, as long as they stay in PostgreSQL 7.2.1 they would work. It is only in the case of upgrading to PostgreSQL7.3.x and beyond that the problem would occur.
So that means that this view should have been created at some point either in OpenACS 4.6 or during the earlier part of the Kernel upgrade.
My suspicion is that the function is already defined because it is defined against the actual table 'acs_privilege_descendant_map' (from earlier version I guess).
So what I need to know is:
- Are my suppositions correct?
- Where SHOULD this view have been created?
- Where will I find the relevant SQL?
- Should I delete the function prior to upgrading?
Many Thanks
Richard
