(Postgrex.Error) ERROR 42601 (syntax_error): syntax error at or near "PARALLEL
Hi,
While trying to upgrade I got a postgres syntax error.
From https://git.pleroma.social/pleroma/pleroma
afb8d9e..4a278cd develop -> origin/develop
+ 5a84d8c...f71740c features/mastoapi-multi-hashtag -> origin/features/mastoapi-multi-hashtag (forced update)
* [new branch] fix-info-id -> origin/fix-info-id
* [new branch] hj-happiness-improvement -> origin/hj-happiness-improvement
* [new branch] user-deletion-rework -> origin/user-deletion-rework
Updating afb8d9e..4a278cd
Fast-forward
...
mix deps.get
mix ecto.migrate
Then this error.
21:51:58.745 [info] == Running Pleroma.Repo.Migrations.UpdateActivityVisibility.up/0 forward
21:51:58.745 [info] execute "create or replace function activity_visibility(actor varchar, recipients varchar[], data jsonb) returns varchar as $$\nDECLARE\n fa varchar;\n public varchar := 'https://www.w3.org/ns/activitystreams#Public';\nBEGIN\n SELECT COALESCE(users.follower_address, '') into fa from users where users.ap_id = actor;\n\n IF data->'to' ? public THEN\n RETURN 'public';\n ELSIF data->'cc' ? public THEN\n RETURN 'unlisted';\n ELSIF ARRAY[fa] && recipients THEN\n RETURN 'private';\n ELSIF not(ARRAY[fa, public] && recipients) THEN\n RETURN 'direct';\n ELSE\n RETURN 'unknown';\n END IF;\nEND;\n$$ LANGUAGE plpgsql IMMUTABLE PARALLEL SAFE SECURITY DEFINER;\n"
** (Postgrex.Error) ERROR 42601 (syntax_error): syntax error at or near "PARALLEL"
(ecto) lib/ecto/adapters/sql.ex:200: Ecto.Adapters.SQL.query!/5
(ecto) lib/ecto/adapters/postgres.ex:96: anonymous fn/4 in Ecto.Adapters.Postgres.execute_ddl/3
(elixir) lib/enum.ex:1925: Enum."-reduce/3-lists^foldl/2-0-"/3
(ecto) lib/ecto/adapters/postgres.ex:96: Ecto.Adapters.Postgres.execute_ddl/3
(ecto) lib/ecto/migration/runner.ex:104: anonymous fn/2 in Ecto.Migration.Runner.flush/0
(elixir) lib/enum.ex:1925: Enum."-reduce/3-lists^foldl/2-0-"/3
(ecto) lib/ecto/migration/runner.ex:102: Ecto.Migration.Runner.flush/0
(stdlib) timer.erl:181: :timer.tc/2
I haven't started Pleroma (so the node is offline). What should I do?
Thanks