You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: