I have installed the PostgreSQL pg_simialrity extension as described here so that I can use the jarowinkler function. The function works perfectly in pgAdmin but not via Spring JDBC. When executed via JDBC this error is reported
org.postgresql.util.PSQLException: ERROR: function jarowinkler(text, text) does not exist
Does anyone know what needs to be done to fix this problem? I am using PostgreSQL 14.0, Java 8, Spring JDBC 4.3.25.RELEASE and PostgreSQL JDBC Driver 42.2.23
Thanks.