I solve the problem now !!!!!! it is working ! 😉 I reindex the index withe the posgres user and it works now! ambari=# REINDEX INDEX pg_type_typname_nsp_index; REINDEX ambari=# \di pg_type_typname_nsp_index; List of relations Schema | Name | Type | Owner | Table -----------+---------------------------+-------+----------+--------- pg_catalog | pg_type_typname_nsp_index | index | postgres | pg_type (1 row) Many thanks to all for the great support! special thanx to Jay SenSharma BOB ... View more