koji ?<br><br>delete package:<br>============<br><pre>psql -U koji koji<br></pre><pre>delete from tag_listing where build_id in (select id from build where pkg_id in (select id from package where name = 'libXext'));<br>
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')));<br>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')));<br>
delete from rpminfo where build_id in (select id from build where pkg_id in (select id from package where name = 'libXext'));<br>delete from build where pkg_id = (select id from package where name = 'libXext');<br>
delete from tag_packages where package_id = (select id from package where name = 'libXext');<br>delete from package where name = 'libXext';</pre><br>delete build :<br>==========<br><pre>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');<br>
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'));<br>
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'));<br>
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');<br>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';<br>
</pre><br>OF CAUSE you must modify it !!! ^-^<br> <br><br><div class="gmail_quote">2010/7/2 Nathan Blackham <span dir="ltr"><<a href="mailto:kemotaha@gmail.com">kemotaha@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I added a package with a typo to a tag. I now have the bad package<br>
name show up in the package list. There are no builds against it. Is<br>
there an easy way to delete?<br>
<br>
I would guess it probably requires a sql query? Anyone have one<br>
handy, to pull it out of all the dependencies?<br>
<br>
Thanks,<br>
Nathan<br>
<font color="#888888">--<br>
buildsys mailing list<br>
<a href="mailto:buildsys@lists.fedoraproject.org">buildsys@lists.fedoraproject.org</a><br>
<a href="https://admin.fedoraproject.org/mailman/listinfo/buildsys" target="_blank">https://admin.fedoraproject.org/mailman/listinfo/buildsys</a><br>
</font></blockquote></div><br>