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/
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-dev Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-dev More help : https://help.launchpad.net/ListHelp
