Description of problem:

It is not possible to delete an empty CCV which was previously published and promoted. 

How reproducible:

Delete the CV from the CCV with: 

hammer content-view remove --id $ID --destroy-content-view yes

Delete the CCV (which is now empty)

Is this issue a regression from an earlier version:

Steps to Reproduce:

1.

2.

3.

Actual behavior:

hammer content-view remove --id 65 --destroy-content-view yes
Could not remove objects from content view:
  PG::NotNullViolation: ERROR:  null value in column "katello_content_view_version_id" of relation "katello_content_view_histories" violates not-null constraint
  DETAIL:  Failing row contains (3858, null, 7, e0c529b2-7c2e-4df2-89c6-203533b8ea28, admin, in progress, null, 2025-07-17 07:11:46.423636, 2025-07-17 07:11:46.423636, 3, null).

[root@satellite rex]#

Expected behavior:

The CCV is deleted.

Business Impact / Additional info:

Found this: https://community.theforeman.org/t/cant-remove-content-view/38403
But cannot be considered as an official solution.