http://cvs.openacs.org/cvs/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0b9-5.2.0b10.sql?rev=1.2&view=log
You need to make sure your content_item__del unsets live and latest revision.
You were right. I found the glitch. It was related to the upgrade scripts that were not executed properly. I executed them and the anomaly went away.
Thanks.