Page MenuHomePhorge
Files F85826704

No OneTemporary
Actions

Authored By
Unknown
Size
2 KB
Referenced Files
None
Subscribers
None

View Options

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..1b880cc67 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
@@ -1,51 +1,51 @@
defmodule Pleroma.Repo.Migrations.AddFtsIndexToObjectsTwo do
use Ecto.Migration
def up do
execute("create extension if not exists rum")
drop_if_exists(
- index(:objects, ["(to_tsvector('english', data->>'content'))"],
+ index(:objects, ["(to_tsvector(data->>'content'))"],
using: :gin,
name: :objects_fts
)
)
alter table(:objects) do
add(:fts_content, :tsvector)
end
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")
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');"
)
execute("CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE ON objects
FOR EACH ROW EXECUTE PROCEDURE objects_fts_update()")
execute("UPDATE objects SET updated_at = NOW()")
end
def down do
execute("drop index if exists objects_fts")
execute("drop trigger if exists tsvectorupdate on objects")
execute("drop function if exists objects_fts_update()")
alter table(:objects) do
remove(:fts_content, :tsvector)
end
create_if_not_exists(
- index(:objects, ["(to_tsvector('english', data->>'content'))"],
+ index(:objects, ["(to_tsvector(data->>'content'))"],
using: :gin,
name: :objects_fts
)
)
end
end

File Metadata

Mime Type
text/x-diff
Expires
Fri, Oct 30, 9:23 AM (19 h, 24 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
1799952
Default Alt Text
(2 KB)

Event Timeline