launchpad-reviewers team mailing list archive
-
launchpad-reviewers team
-
Mailing list archive
-
Message #32448
[Merge] ~alvarocs/launchpad:db-indexes-craft-platforms into launchpad:master
Alvaro Crespo Serrano has proposed merging ~alvarocs/launchpad:db-indexes-craft-platforms into launchpad:master.
Commit message:
2211-33-2: Remove 'concurrently' from the creation of indexes for craft_platform table
Requested reviews:
Launchpad code reviewers (launchpad-reviewers)
For more details, see:
https://code.launchpad.net/~alvarocs/launchpad/+git/launchpad/+merge/485402
--
Your team Launchpad code reviewers is requested to review the proposed merge of ~alvarocs/launchpad:db-indexes-craft-platforms into launchpad:master.
diff --git a/database/schema/patch-2211-33-2.sql b/database/schema/patch-2211-33-2.sql
index 9fe9cf2..4f896c9 100644
--- a/database/schema/patch-2211-33-2.sql
+++ b/database/schema/patch-2211-33-2.sql
@@ -3,13 +3,13 @@
SET client_min_messages = ERROR;
-CREATE INDEX CONCURRENTLY charmrecipebuild__craft_platform__idx
+CREATE INDEX charmrecipebuild__craft_platform__idx
ON CharmRecipeBuild (craft_platform);
-CREATE INDEX CONCURRENTLY rockrecipebuild__craft_platform__idx
+CREATE INDEX rockrecipebuild__craft_platform__idx
ON RockRecipeBuild (craft_platform);
-CREATE INDEX CONCURRENTLY snapbuild__craft_platform__idx
+CREATE INDEX snapbuild__craft_platform__idx
ON SnapBuild (craft_platform);
-CREATE INDEX CONCURRENTLY craftrecipebuild__craft_platform__idx
+CREATE INDEX craftrecipebuild__craft_platform__idx
ON CraftRecipeBuild (craft_platform);
INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 33, 2);