Stuart Bishop has proposed merging lp:~stub/launchpad/pending-db-changes into lp:launchpad/db-devel.
Requested reviews: Launchpad code reviewers (launchpad-reviewers) For more details, see: https://code.launchpad.net/~stub/launchpad/pending-db-changes/+merge/98184 = Summary = BugTag was missing a foreign key reference. We have a spurious Python handler causing pg_upgrade to barf. == Proposed fix == Fix the problems. == Pre-implementation notes == == Implementation details == == Tests == == Demo and Q/A == = Launchpad lint = Checking for conflicts and issues in changed files. Linting changed files: database/schema/patch-2209-15-2.sql == Schema == -- https://code.launchpad.net/~stub/launchpad/pending-db-changes/+merge/98184 Your team Launchpad code reviewers is requested to review the proposed merge of lp:~stub/launchpad/pending-db-changes into lp:launchpad/db-devel.
=== added file 'database/schema/patch-2209-15-2.sql' --- database/schema/patch-2209-15-2.sql 1970-01-01 00:00:00 +0000 +++ database/schema/patch-2209-15-2.sql 2012-03-19 11:15:27 +0000 @@ -0,0 +1,11 @@ +SET client_min_messages=ERROR; + +-- Missing foreign key constraint. +ALTER TABLE BugTag ADD CONSTRAINT bugtag__bug__fk FOREIGN KEY (bug) REFERENCES Bug; + +-- We managed to get a second plpython handler installed in the public +-- namespace that is blocking pg_upgrade upgrades. PGBug #6532, +-- investigation on root cause ongoing. +DROP FUNCTION public.plpython_call_handler(); + +INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 15, 2);
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
