← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

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

  • Committer: Stuart Bishop
  • Date: 2011-06-13 16:56:15 UTC
  • mto: (7675.1045.496 db-devel)
  • mto: This revision was merged to the branch mainline in revision 13402.
  • Revision ID: stuart.bishop@canonical.com-20110613165615-f5ap0g2r7v2q3w0d
Update

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-75-0.sql
438
438
    IF TG_OP = 'UPDATE' THEN
439
439
        IF OLD.duplicateof IS DISTINCT FROM NEW.duplicateof
440
440
            OR OLD.private IS DISTINCT FROM NEW.private
441
 
            OR OLD.has_patch IS DISTINCT FROM NEW.has_patch
442
 
            OR OLD.fixed_upstream IS DISTINCT FROM NEW.fixed_upstream THEN
 
441
            OR (OLD.latest_patch_uploaded IS NULL)
 
442
                <> (NEW.latest_patch_uploaded IS NULL) THEN
443
443
            PERFORM unsummarise_bug(OLD);
444
444
            PERFORM summarise_bug(NEW);
445
445
        END IF;
489
489
            OR OLD.distroseries IS DISTINCT FROM NEW.distroseries
490
490
            OR OLD.sourcepackagename IS DISTINCT FROM NEW.sourcepackagename
491
491
            OR OLD.status IS DISTINCT FROM NEW.status
492
 
            OR OLD.milestone IS DISTINCT FROM NEW.milestone
493
 
            OR OLD.has_patch IS DISTINCT FROM NEW.has_patch
494
 
            OR OLD.fixed_upstream IS DISTINCT FROM NEW.fixed_upstream) THEN
 
492
            OR OLD.bugwatch IS DISTINCT FROM NEW.bugwatch
 
493
            OR OLD.milestone IS DISTINCT FROM NEW.milestone) THEN
 
494
 
495
495
            IF TG_WHEN = 'BEFORE' THEN
496
496
                PERFORM unsummarise_bug(bug_row(OLD.bug));
497
497
                IF OLD.bug <> NEW.bug THEN