diff options
| author | hyperion <8027-hyperion@users.noreply.git.pleroma.social> | 2021-02-06 09:42:17 +0000 |
|---|---|---|
| committer | rinpatch <rinpatch@sdf.org> | 2021-02-06 09:42:17 +0000 |
| commit | 8d4e0342e1b5ebbe486dc538e3c8fe81d53220e6 (patch) | |
| tree | 0f8779125f24793369647b632397ee10850e53a3 /priv | |
| parent | 7f0787163999fc0ac0c6fcfd0c13f80c5a55266d (diff) | |
| download | pleroma-8d4e0342e1b5ebbe486dc538e3c8fe81d53220e6.tar.gz pleroma-8d4e0342e1b5ebbe486dc538e3c8fe81d53220e6.zip | |
Update priv/repo/migrations/20190501125843_add_fts_index_to_objects.exs, priv/repo/optional_migrations/rum_indexing/20190510135645_add_fts_index_to_objects_two.exs files
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") |