MagicStack/asyncpg

Using pg_trgm extension

pedrorjbr opened this issue · 0 comments

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)

Image

asyncpg==0.30.0
PostgreSQL 15.10