koji ? delete package: ============
psql -U koji koji delete from tag_listing where build_id in (select id from build where pkg_id in (select id from package where name = 'libXext')); delete from rpmsigs where rpm_id in (select id from rpminfo where build_id in (select id from build where pkg_id in (select id from package where name = 'libXext'))); delete from buildroot_listing where rpm_id in (select id from rpminfo where build_id in (select id from build where pkg_id in (select id from package where name = 'libXext'))); delete from rpminfo where build_id in (select id from build where pkg_id in (select id from package where name = 'libXext')); delete from build where pkg_id = (select id from package where name = 'libXext'); delete from tag_packages where package_id = (select id from package where name = 'libXext'); delete from package where name = 'libXext'; delete build : ========== delete from tag_listing where build_id in (select id from build where pkg_id = (select id from package where name = 'serefpolicy') and version = '2.4.6' and release = '203.el5.ns5.se.09'); delete from rpmsigs where rpm_id in (select id from rpminfo where build_id in (select id from build where pkg_id = (select id from package where name = 'serefpolicy') and version = '2.4.6' and release = '203.el5.ns5.se.09')); delete from buildroot_listing where rpm_id in (select id from rpminfo where build_id in (select id from build where pkg_id = (select id from package where name = 'serefpolicy') and version = '2.4.6' and release = '203.el5.ns5.se.09')); delete from rpminfo where build_id in (select id from build where pkg_id = (select id from package where name = 'serefpolicy') and version = '2.4.6' and release = '203.el5.ns5.se.09'); delete from build where pkg_id = (select id from package where name = 'serefpolicy') and version = '2.4.6' and release = '203.el5.ns5.se.09'; OF CAUSE you must modify it !!! ^-^ 2010/7/2 Nathan Blackham <[email protected]> > I added a package with a typo to a tag. I now have the bad package > name show up in the package list. There are no builds against it. Is > there an easy way to delete? > > I would guess it probably requires a sql query? Anyone have one > handy, to pull it out of all the dependencies? > > Thanks, > Nathan > -- > buildsys mailing list > [email protected] > https://admin.fedoraproject.org/mailman/listinfo/buildsys >
-- buildsys mailing list [email protected] https://admin.fedoraproject.org/mailman/listinfo/buildsys
