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?