fix(migrations) remove unnecessary postgres index on workspaces table

bungle · bungle · commit 514601a6319e · 2020-08-20T17:13:17.000+03:00
### Summary

This removes possibly existing index from users that have used an older
version of `2.1.0` migrations that added additional index on `unique`
column, which is not necessary as unique constraint already adds an index.
diff --git a/kong-2.1.2-0.rockspec b/kong-2.1.2-0.rockspec
@@ -198,6 +198,7 @@ build = {
     ["kong.db.migrations.core.008_150_to_200"] = "kong/db/migrations/core/008_150_to_200.lua",
     ["kong.db.migrations.core.009_200_to_210"] = "kong/db/migrations/core/009_200_to_210.lua",
     ["kong.db.migrations.core.010_210_to_211"] = "kong/db/migrations/core/010_210_to_211.lua",
+    ["kong.db.migrations.core.011_212_to_213"] = "kong/db/migrations/core/011_212_to_213.lua",
     ["kong.db.migrations.operations.200_to_210"] = "kong/db/migrations/operations/200_to_210.lua",
     ["kong.db.migrations.operations.210_to_211"] = "kong/db/migrations/operations/210_to_211.lua",
 
diff --git a/kong/db/migrations/core/011_212_to_213.lua b/kong/db/migrations/core/011_212_to_213.lua
@@ -0,0 +1,11 @@
+return {
+  postgres = {
+    up = [[
+      -- Unique constraint on "name" already adds btree index
+      DROP INDEX IF EXISTS "workspaces_name_idx";
+    ]],
+  },
+  cassandra = {
+    up = [[]],
+  }
+}
diff --git a/kong/db/migrations/core/init.lua b/kong/db/migrations/core/init.lua
@@ -8,4 +8,5 @@ return {
   "008_150_to_200",
   "009_200_to_210",
   "010_210_to_211",
+  "011_212_to_213",
 }

Original file line number	Diff line number	Diff line change
`@@ -8,4 +8,5 @@ return {`
`8`	`8`	`"008_150_to_200",`
`9`	`9`	`"009_200_to_210",`
`10`	`10`	`"010_210_to_211",`
	`11`	`+ "011_212_to_213",`
`11`	`12`	`}`