[Spacewalk-list] Channel Deletion Problem - v1.4

[Speagle, Andy]

> > [root at spacewalk ~]# echo "select delete_rule from user_constraints
> > where constraint_name = 'RHN_ENQUEUE_CID_FK';" | spacewalk-sql
> > --select-mode -
> >
> > DELETE_RU
> > ---------
> > NO ACTION
> >
> > > Is this a fresh Spacewalk 1.4 installation or upgraded system?
> >
> > This is a long-upgraded 1.4 installation... from 0.5 or so...
> 
> Please run
> 
> 	http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=sche
> ma/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/001-add-
> missing-cascade-on-
> delete.sql.oracle;hb=d5ccd232dedff450db9d833532051c6f9a7bef2a
> 
> against your database schema -- that will add the missing ON DELETE
> CASCADE clauses and make your schema be like brand new. Then the channel
> delete should not block on the constraint(s) where it blocked before and
> hopefully proceed.
> 
> Thank you for bringing this issue to our attention.

Thanks, Jan.  That resolved the issue for me.

-Andy