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 <kemotaha@gmail.com>
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
buildsys@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/buildsys