supabase / auth / 19457587480

69%

push

github

fix(indexworker): detect which schema `pg_trgm` exists in (#2260)

The `pg_trgm` extension might already exist under a different schema, in
which case, the create index statements will need to reference the
schema when using the extension if the extension is not part of the
`search_path`.

This PR:

- removes the migration to create the `pg_trgm` extension
- looks for which schema the extension might live in
- adds a check in the indexworker to ensure the extension exists before
proceeding
- this is mostly a nice-to-have as any failed indexes would be
transparently re-created next time the worker runs

22 of 22 new or added lines in 1 file covered. (100.0%)

14369 of 21013 relevant lines covered (68.38%)

77.73 hits per line