I posted a detailed report in the bug for this:
https://openacs.org/bugtracker/openacs/bug?format=table&bug%5fnumber=2413Basically, content_item__delete works fine for plain content_revision types.
So the error message is not correct. Something else is causing a RI error, and the pl/sql proc is returning that message although its not the actual error.
More debugging is needed. Any details you can give would be really helpful.