Forum OpenACS Development: Duplication in acs_sc_impls

Collapse
Posted by Harish Krishnan on
I found that duplication in acs_sc_impls on impl_id for same contract name and impl_name can cause problems for many methods. Is it proper to have a constraint on contract_name and impl_name making them unique?

Will adding this contraint cause any issues? For that matter not having _is_ causing a problem.

Regards
Harish

Collapse
Posted by Lars Pind on
I think we should have that constraint, yes.

Where are you seeing problems?

/Lars

Collapse
Posted by Harish Krishnan on
The problem occurred due to improper drop scripts. Re installing the package caused the whole site to screw up as I was running dotlrn which depends heavily on service contracts to display portlets.
I believe there is another table acs_sc_operations which lacks constraint for uniquely identifying a operation on  contract_name and operation_name. There are quite a few procs depending on this condition.