The composite_p attribute for acs_object_type.create_type() was missing
This fixes in essence the following errors. acs_rel_type.create_type ( * ERROR at line 35: ORA-06550: line 35, column 2: PLS-00306: wrong number or types of arguments in call to 'CREATE_TYPE' ORA-06550: line 35, column 2: PL/SQL: Statement ignored ORA-06550: line 54, column 2: PLS-00306: wrong number or types of arguments in call to 'CREATE_TYPE' ORA-06550: line 54, column 2: PL/SQL: Statement ignored ORA-06550: line 70, column 2: PLS-00306: wrong number or types of arguments in call to 'CREATE_TYPE' ORA-06550: line 70, column 2: PL/SQL: Statement ignored No errors
insert into group_type_rels * ERROR at line 1: ORA-02291: integrity constraint (OPENACS.GROUP_TYPE_RELS_GROUP_TYPE_FK) violated - parent key not found insert into group_type_rels * ERROR at line 1: ORA-02291: integrity constraint (OPENACS.GROUP_TYPE_RELS_GROUP_TYPE_FK) violated - parent key not found
Added index on foreign key column to reduce sequential reads on delete operations, since the optimizer brain fart ((c)Don Baccus) that existed 17 years ago in pg 7.2 seems to be gone (https://openacs.org/forums/message-view?message_id=142769)