X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=priv%2Frepo%2Fmigrations%2F20190109152453_add_visibility_function.exs;h=43d1074aa7327f5febe7dd744c0b2d4dde6cd022;hb=da44ee5b0f6207666442b956ab2cdef3e5e9b49b;hp=6c94f1bb372adf9f6c58d559d802b0b9cfccfe68;hpb=5027f82cdef52391e408428ecc8013b1c4847b6b;p=akkoma

diff --git a/priv/repo/migrations/20190109152453_add_visibility_function.exs b/priv/repo/migrations/20190109152453_add_visibility_function.exs
index 6c94f1bb3..43d1074aa 100644
--- a/priv/repo/migrations/20190109152453_add_visibility_function.exs
+++ b/priv/repo/migrations/20190109152453_add_visibility_function.exs
@@ -1,5 +1,6 @@
 defmodule Pleroma.Repo.Migrations.AddVisibilityFunction do
   use Ecto.Migration
+  @disable_ddl_transaction true
 
   def up do
     definition = """
@@ -29,18 +30,21 @@ defmodule Pleroma.Repo.Migrations.AddVisibilityFunction do
 
     create(
       index(:activities, ["activity_visibility(actor, recipients, data)"],
-        name: :activities_visibility_index
+        name: :activities_visibility_index,
+        concurrently: true
       )
     )
   end
 
   def down do
-    drop(
+    drop_if_exists(
       index(:activities, ["activity_visibility(actor, recipients, data)"],
         name: :activities_visibility_index
       )
     )
 
-    execute("drop function activity_visibility(actor varchar, recipients varchar[], data jsonb)")
+    execute(
+      "drop function if exists activity_visibility(actor varchar, recipients varchar[], data jsonb)"
+    )
   end
 end