yes koji. Thanks, I will try it in the morning. Nathan
On Thu, Jul 1, 2010 at 6:40 PM, Eric Zhong <[email protected]> wrote: > 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 > -- buildsys mailing list [email protected] https://admin.fedoraproject.org/mailman/listinfo/buildsys
