I am not sure what your question is with the procedure content_item__set_live_revision. It accepts a revision_id as a parameter, but always returns 0.
With the get_content_value procedure it appears that is not supported by postgresql. We will have to look into making that procedure smarter to correctly return the content if it is a file or text or a binary object.
