Forum OpenACS Q&A: Re: content_item__delete referential integrity error

Collapse
Posted by tammy m on

OK

Well no one answered me and I got impatient. Surprise!

So I did this:

update cr_items set latest_revision = null where content_type like 'orp_%' \g

It's ok I think since I'm deleting all items of that particular content type;)

Then I was able to issue select content_item__delete(6414) from dual \g no problem.

Yet my question remains... Is this the right way to go about deleting content items? It seems like if so, that content_item__delete should just do this for me as well. So I must be missing something.

Can someone please enlighten me on the right way to delete content items I have lying around the db that I don't want anymore? Are there more steps than calling content_item__delete?

thanks again