Comment 2 for bug 196774

Revision history for this message
Curtis Hovey (sinzui) wrote :

There are 81 bad packages in staging. I think we can clean fix this constraint, then fix the bad package

select
    distroseries.name as distroseries,
    sourcepackagename.name as sourcepackagename,
    count(sourcepackagename.name)
from
    packaging, sourcepackagename, distroseries
where
    packaging.sourcepackagename = sourcepackagename.id
    and packaging.distroseries = distroseries.id
group by
    distroseries.name, sourcepackagename.name
having count(sourcepackagename.name) > 1
order by
    distroseries.name, sourcepackagename.name;