diff options
author | rinpatch <rinpatch@sdf.org> | 2021-02-06 09:42:20 +0000 |
---|---|---|
committer | rinpatch <rinpatch@sdf.org> | 2021-02-06 09:42:20 +0000 |
commit | 6e68058b634dced932a1283f8470598b5cabdfeb (patch) | |
tree | cff4438fa7728536571f9c5ad91eef263c18cd5e /priv | |
parent | 4dd28b4bd1c49d61018ae607a6775649e4d323bf (diff) | |
parent | 8d4e0342e1b5ebbe486dc538e3c8fe81d53220e6 (diff) |
Merge branch 'feat/allow_alt_text_search_config' into 'develop'
allow user defined text search config in database
See merge request pleroma/pleroma!3275
Diffstat (limited to 'priv')
-rw-r--r-- | priv/repo/migrations/20210121080964_add_default_text_search_config.exs | 11 | ||||
-rw-r--r-- | priv/repo/optional_migrations/rum_indexing/20190510135645_add_fts_index_to_objects_two.exs | 2 |
2 files changed, 12 insertions, 1 deletions
diff --git a/priv/repo/migrations/20210121080964_add_default_text_search_config.exs b/priv/repo/migrations/20210121080964_add_default_text_search_config.exs new file mode 100644 index 000000000..09b6cccc9 --- /dev/null +++ b/priv/repo/migrations/20210121080964_add_default_text_search_config.exs @@ -0,0 +1,11 @@ +defmodule Pleroma.Repo.Migrations.AddDefaultTextSearchConfig do + use Ecto.Migration + + def change do + execute("DO $$ + BEGIN + execute 'ALTER DATABASE '||current_database()||' SET default_text_search_config = ''english'' '; + END + $$;") + end +end diff --git a/priv/repo/optional_migrations/rum_indexing/20190510135645_add_fts_index_to_objects_two.exs b/priv/repo/optional_migrations/rum_indexing/20190510135645_add_fts_index_to_objects_two.exs index 82e02281d..88476fb57 100644 --- a/priv/repo/optional_migrations/rum_indexing/20190510135645_add_fts_index_to_objects_two.exs +++ b/priv/repo/optional_migrations/rum_indexing/20190510135645_add_fts_index_to_objects_two.exs @@ -17,7 +17,7 @@ defmodule Pleroma.Repo.Migrations.AddFtsIndexToObjectsTwo do execute("CREATE FUNCTION objects_fts_update() RETURNS trigger AS $$ begin - new.fts_content := to_tsvector('english', new.data->>'content'); + new.fts_content := to_tsvector(new.data->>'content'); return new; end $$ LANGUAGE plpgsql") |