Launchpad itself

Merge lp:~abentley/launchpad/blueprint-info-type-idx into lp:launchpad

  1. blueprint-info-type-idx
  2. Merge into devel
Proposed by Aaron Bentley
Status: Merged
Approved by: Aaron Bentley
Approved revision: no longer in the source branch.
Merged at revision: 15850
Proposed branch: lp:~abentley/launchpad/blueprint-info-type-idx
Merge into: lp:launchpad
Prerequisite: lp:~abentley/launchpad/blueprint-info-type-db
Diff against target: 12 lines (+8/-0)
1 file modified
database/schema/patch-2209-28-2.sql (+8/-0)
To merge this branch: bzr merge lp:~abentley/launchpad/blueprint-info-type-idx
Reviewer Review Type Date Requested Status
Stuart Bishop (community) db Approve
Robert Collins db Pending
Review via email: mp+117980@code.launchpad.net

Commit message

Add index to Specification.information_type

Description of the change

= Summary =
Add an index to Specification.information_type
Previous: https://code.launchpad.net/~abentley/launchpad/blueprint-info-type-db/+merge/117979
Next: https://code.launchpad.net/~abentley/launchpad/blueprint-info-type-code/+merge/117981

== Pre-implementation notes ==
Discussed with lifeless and wgrant

== LOC Rationale ==
Part of Private Projects

== Implementation details ==
Did not use CREATE INDEX CONCURRENTLY, because "make schema" complained about transactions.
Hot patch targeted at devel per lifeless' directions.

== Tests ==
None

== Demo and Q/A ==
None

= Launchpad lint =

Checking for conflicts and issues in changed files.

Linting changed files:
  database/schema/patch-2209-28-1.sql
  database/schema/comments.sql
  database/schema/patch-2209-28-2.sql

To post a comment you must log in.
Revision history for this message
Stuart Bishop (stub) :
review: Approve (db)
Revision history for this message
Stuart Bishop (stub) wrote :

Yes, patches shouldn't include CONCURRENTLY. This needs to be added in by me or webops when applying live.

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== added file 'database/schema/patch-2209-28-2.sql'
2--- database/schema/patch-2209-28-2.sql 1970-01-01 00:00:00 +0000
3+++ database/schema/patch-2209-28-2.sql 2012-08-02 19:50:26 +0000
4@@ -0,0 +1,8 @@
5+-- Copyright 2012 Canonical Ltd. This software is licensed under the
6+-- GNU Affero General Public License version 3 (see the file LICENSE).
7+
8+SET client_min_messages=ERROR;
9+
10+CREATE INDEX specification__information_type__idx ON Specification(information_type);
11+
12+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 28, 2);