~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-62-0.sql

  • Committer: Stuart Bishop
  • Date: 2011-05-25 11:32:36 UTC
  • mto: (7675.1045.417 db-devel)
  • mto: This revision was merged to the branch mainline in revision 13163.
  • Revision ID: stuart.bishop@canonical.com-20110525113236-xvk4k0ihy8zhao32
Restore primary key index name to what Slony-I expects

Show diffs side-by-side

added added

removed removed

Lines of Context:
29
29
    DROP COLUMN id,
30
30
    DROP CONSTRAINT revision__branch__revision__key;
31
31
 
 
32
-- Rename our new primary key index to the old name to keep Slony-I happy.
 
33
ALTER INDEX revision__revision__branch__key RENAME TO revisionnumber_pkey;
 
34
 
32
35
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 62, 0);
33
36