Normally I would delete the revisions first.
Something like
select content_revision__delete(revision_id) from cr_revisions where item_id = :to_be_deleted_item;
Then you delete the content item
select content_item__delete(:to_be_deleted_item);
Although as mentioned by Rob, it seems to already work well in the latest version.
