postgresql7.1 select count(*) from cr_revisions where item_id = :file_id and acs_permission__permission_p(revision_id,:user_id,'delete') = 'f' select content_item__delete(:file_id); select title as file_name from cr_revisions where revision_id = content_item__get_live_revision(:file_id)