launchpad-dev team mailing list archive

[Curtis Hovey <curtis.hovey@xxxxxxxxxxxxx>]

I am looking into bug 523901 duplicate packaging links
<https://bugs.edge.launchpad.net/bugs/523901>.

I thought this was fix by a change the the UI forms and a db patch to
prevent two or more project series from creating a packaging link to a
distribution series source package. I see patch-2207-09-0.sql is in the
tree:

        -- Per Bug #196774
        ALTER TABLE Packaging
            DROP CONSTRAINT packaging_uniqueness,
            ADD CONSTRAINT packaging__distroseries__sourcepackagename__key
                UNIQUE (distroseries, sourcepackagename);
        
        INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 9, 0);


but it does not look like it is applied:

        lpmain_staging=> \d packaging
        ...
        Indexes:
            "packaging_pkey" PRIMARY KEY, btree (id)
            "packaging_uniqueness" UNIQUE, btree (distroseries, sourcepackagename, productseries)
            "packaging__distroseries__sourcepackagename__idx" btree (distroseries, sourcepackagename)
            "packaging__owner__idx" btree (owner)
            "packaging_sourcepackagename_idx" btree (sourcepackagename)
        Foreign-key constraints:
            "packaging__distroseries__fk" FOREIGN KEY (distroseries) REFERENCES distroseries(id)
            "packaging_owner_fk" FOREIGN KEY (owner) REFERENCES person(id)
            "packaging_productseries_fk" FOREIGN KEY (productseries) REFERENCES productseries(id)
            "packaging_sourcepackagename_fk" FOREIGN KEY (sourcepackagename) REFERENCES sourcepackagename(id)
        Triggers:
            _sl_logtrigger_363 AFTER INSERT OR DELETE OR UPDATE ON packaging FOR EACH ROW EXECUTE PROCEDURE _sl.logtrigger('_sl', '363', 'vkvvvvvv')

-- 
__Curtis C. Hovey_________
http://launchpad.net/

Attachment: signature.asc
Description: This is a digitally signed message part