yes koji. Thanks, I will try it in the morning.
Nathan
On Thu, Jul 1, 2010 at 6:40 PM, Eric Zhong <ericiszhongwenjia(a)gmail.com> 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 <kemotaha(a)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(a)lists.fedoraproject.org
>
https://admin.fedoraproject.org/mailman/listinfo/buildsys
--
buildsys mailing list
buildsys(a)lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/buildsys