X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=priv%2Frepo%2Foptional_migrations%2Frum_indexing%2F20190510135645_add_fts_index_to_objects_two.exs;h=757afa129fb3ec7e5a83bd4fbc28cb786183abd5;hb=61180ab6f4b85ab78de2eaf1bc1b974c9e7908af;hp=6227769dccc8081cce8a343109c3b9cce235dbd3;hpb=85c7916c94017c6a3657a3540f1e6c3afcb78225;p=akkoma 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 6227769dc..757afa129 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 @@ -10,8 +10,8 @@ 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'); - return new; + new.fts_content := to_tsvector('english', new.data->>'content'); + return new; end $$ LANGUAGE plpgsql") execute("create index if not exists objects_fts on objects using RUM (fts_content rum_tsvector_addon_ops, inserted_at) with (attach = 'inserted_at', to = 'fts_content');")