Xavier Babu
09/16/2022, 5:01 PMRyan Peden
09/16/2022, 5:15 PMpg_tgrm
extension installed in one of the schemas visible to the database user that you put in the connection string.Xavier Babu
09/16/2022, 5:16 PMRyan Peden
09/16/2022, 5:17 PMpg_tgrm
to was not in the user account's search path in Postgres.Xavier Babu
09/16/2022, 5:20 PMXavier Babu
09/16/2022, 5:20 PMXavier Babu
09/16/2022, 5:21 PMXavier Babu
09/16/2022, 5:22 PMXavier Babu
09/16/2022, 5:22 PMRyan Peden
09/16/2022, 5:24 PMgeneric_as_tools_user_dev
and run show search_path;
it should tell youRyan Peden
09/16/2022, 5:24 PMRyan Peden
09/16/2022, 5:25 PMpg_trgm
is missing from the search path, you'd probably want to use the alter role
example from that link to permanently add the schema to the user's search pathXavier Babu
09/16/2022, 5:28 PMXavier Babu
09/16/2022, 5:30 PMRyan Peden
09/16/2022, 5:31 PMXavier Babu
09/28/2022, 10:36 PM