Project

General

Profile

Feature #15106

Updated by Peter Amstutz almost 5 years ago

Add a migration that creates trigram indexes on columns currently searchable by full text search.    This should concatenate columns to create a single expression index (eg name || description || file_names). 

 Migration should execute "create extension pg_trgm" and provide a useful error message if the extension is not available (should advise the user to install postgres-contrib and/or link to the migration notes).  

 Update workbench2 workbench (1? 2?) search bar to use ["any", "ilike", "%term%"] instead of '@@'.    Workbench should perform splitting of the search on whitespace and add a separate search clause for each term. 

Back