Description
I am using sql alchemy with pg_trgm ( similarity function) extension.
I have alredy installed the pg_trgm extension. Executing the query directly from SQL UI, like dbeaver, it works. But on production, throgh sql alchemy and asyncpg....
I am getting:
File "asyncpg/protocol/protocol.pyx", line 165, in prepare
asyncpg.exceptions.UndefinedFunctionError: function similarity(character varying, character varying) does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
The query seems to be right:
SELECT dr_consulta.practitioners.name, dr_consulta.practitioners.gender, dr_consulta.practitioners.nrp, dr_consulta.practitioners.nrp_type, dr_consulta.practitioners.nrp_uf, dr_consulta.practitioners.external_id, dr_consulta.practitioners.id, dr_consulta.practitioners.created_at, dr_consulta.practitioners.updated_at, similarity(dr_consulta.practitioners.name, $1::VARCHAR) AS sim \nFROM dr_consulta.practitioners ORDER BY sim DESC \n LIMIT $2::INTEGER]\n[parameters: ('Renata Fortes Itagyba', 5)
asyncpg==0.30.0
PostgreSQL 15.10