authorization and indexes problem
Only the owner of the table can create an index. There are tables that are owned by the hived user (this which inherits from hived_group ROLE ), those tables are shared among all haf applications running on the same database (irreversible/reversible tables). It turned out that the applications may have their own requirements for indexes, for example, HafaH requires
CREATE INDEX IF NOT EXISTS hive_operations_block_num_id_idx ON hive.operations USING btree(block_num, id);. Currently, the only method to create such an index is to create it during creating the hive_fork_manager extension and in consequence will affect all the applications, which may be undesired.