NgramSearch doesn't handle mt_grams_vector function outside of public schema

[claudiolassala]

I had Marten configured to use separate read and write schemas (inspired by GoldenEye).

NgramSearch fails to find the mt_grams_vector in my "read" schema. When building the WhereFragment, it doesn't handle looking for that function anywhere but in the "public" schema.

[apereiratl]

Well, the functions are added using the built-in marten functionality. Are you saying you expect these functions to be added to all schemas?

[mysticmind]

I have zeroed on the issue. This will require the following changes:

• Access to database schema in the

  marten/src/Marten/Linq/Parsing/Methods/NgramSearch.cs

  Line 23 in 81cf3c2

  return new WhereFragment($"mt_grams_vector({locator}) @@ mt_grams_query(?)", values);

  so that we can qualify the ngram search related functions i.e. mt_grams_vector and mt_grams_query to use the one from the schema.
• Also the SQL files (mt_grams_query.sql and mt_grams_vector.sql) will need to be fixed to ensure they are qualified with the schema name for function usage.