IntegrityError: duplicate key value violates unique constraint "packaging_uniqueness"

[Cody A.W. Somerville]

I setup a new project xubuntu-docs and setup my series and linked them to branches. Then I went to link the series to packages and did so via $project/$series/+ubuntupkg - typing "xubuntu-docs" into the field each time. Unfortunately, launchpad linked them all against the jaunty series in Ubuntu which caused the IntegrityError: duplicate key value violates unique constraint "packaging_uniqueness" when I attempted to modify the link via https://edge.launchpad.net/ubuntu/jaunty/+source/xubuntu-docs/+edit-packaging

[Curtis Hovey (sinzui)]

Source package linking appears to be flawed. I have seen unwanted linking to series before. I think we want to collect the source package bugs into one to two stories that we can address in the 2.2.5 cycle.

[Curtis Hovey (sinzui)]

OOPS-1377EA3 was caused by me trying to set /ubuntu/karmic/+source/metacity to /metacity/main. The view return an error during validate() and report which package claims the series.

[Curtis Hovey (sinzui)]

Let me restate that:
The view *should* return an error during validate() and report which package claims the series.

[Curtis Hovey (sinzui)]

This bug is ultimately a duplicate of of bug 196774. the constraint is violated because the link to the product series already exists, but UI is no showing it. In this scenario, we want to delete this package that is shadowing the legitimate package. We will fix the 81 bad packages and change the constraint to prevent the extra package from being created.