# Pg\_trgm Extension used for querying

**URL:** <https://forums.percona.com/t/pg-trgm-extension-used-for-querying/16286>\
**Category:** PostgreSQL\
**Created:** [June 24, 2022, 7:46am UTC](https://forums.percona.com/t/pg-trgm-extension-used-for-querying/16286 "2022-06-24T07:46:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prerna\_Goyal](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/prerna_goyal/32/5553_2.png) [@Prerna\_Goyal](https://forums.percona.com/u/Prerna_Goyal)\
**Post date:** [June 24, 2022, 7:46am UTC](https://forums.percona.com/t/pg-trgm-extension-used-for-querying/16286/1 "2022-06-24T07:46:53Z")

</div>

The extension pg\_trgm does not work after some time while recreating the extension solves the error.

Can there be a solution for permanent solution for this as it is breaking things where the extension fails?

---

<div class="post-metadata">

**Author:** ![Robert\_Bernier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/robert_bernier/32/1367_2.png) [@Robert\_Bernier](https://forums.percona.com/u/Robert_Bernier)\
**Post date:** [June 24, 2022, 1:15pm UTC](https://forums.percona.com/t/pg-trgm-extension-used-for-querying/16286/2 "2022-06-24T13:15:15Z")

</div>

Hi,

Sorry to hear you’re having challenges with extension pg\_trgm. That sounds pretty unusual however that being said and since extension pg\_trm is part of the standard postgres installation you should file a bug report on the postgresql portal. Take a look at the reference links below and follow the guidelines as outlined for filing bug reports.

Hope this helps!

REFERENCES:  
[PostgreSQL: Documentation: 14: F.33.&nbsp;pg\_trgm](https://www.postgresql.org/docs/current/pgtrgm.html)  
[PostgreSQL: Documentation: 14: 5.&nbsp;Bug Reporting Guidelines](https://www.postgresql.org/docs/14/bug-reporting.html)