SanteDB 2.1.161+ on PostgreSQL 10 returns "websearch_to_tsquery" error
Issue: After installing an upgrade for a SanteDB iCDR server to 2.1.161, the service starts however, when attempting to perform a freetext search (with
_any
) the user receives an error that websearch_to_tsquery
is not a function.Applies To:
- SanteDB iCDR (Version 2.1.161+) on PostgreSQL 10
Symptoms:
- When performing a query that uses
_any
the iCDR returns an error thatwebsearch_to_tsquery
is not available
Solutions:
- 1.Open a SQL command prompt to your PostgreSQL 10 server
- 2.Re-create the
fti_tsquery
stored procedure to use a different algorithm:
CREATE OR REPLACE FUNCTION websearch_to_tsquery (term_in IN TEXT)
RETURNS tsquery
IMMUTABLE AS
$$
BEGIN
RETURN TO_TSQUERY(ARRAY_TO_STRING(STRING_TO_ARRAY(TERM_IN, ' '), ' & '));
END;q
$$ LANGUAGE plpgsql;
Last modified 1yr ago