I just ran content-test.sql, and it worked correctly. content-test.sql runs a variety of tests on the CR, and it deletes all of the content items at the end, so it looks like content_item__delete works correctly. Are you running the latest code from cvs? Also what version of postgresql are you running?