[Solved] pg_trgm extension

[wambachr]

Hi, i would like to create indixes used by the like-phrase

 

something like select name from collected_admin_boundaries where name ilike 'san %';

 

This type of query will only use trgm-indices which can be created using

create index idx_collected_admin_boundaries_name on collected_admin_boundaries using gin(name gin_trgm_ops);

 

But for that i need the extension pg_trbn, which is installed but not activated.

 

wambachr_osm=> create extension pg_trgm with schema pg_catalog;

ERROR:  permission denied to create extension "pg_trgm"
HINT:  Must be superuser to create this extension.
Time: 2486,759 ms (00:02,487)

 

Regards

walter

Edited May 13, 2021 by wambachr

[OnEnemy]

Please post the following information:

• Your cPanel username
  
• Your main domain
  
• The server that you are on
  

[wambachr]

sorry

 

username:                 wambachr

main domain               wambachr.heliohost.org

postgresql-database:      wambachr_osm

server:                   tommy

 

regards

walter

[OnEnemy]

This support request is being escalated to our root admins.

[Krydos]

The pg_trgm extension has been created on wambachr_osm.

[wambachr]

thanks,

 

working fine

 

regards

walter

Edited May 14, 2021 by wambachr