postgresql7.1 select title, revision_id from cr_revisions where item_id = :item_id and revision_id = content_item__get_latest_revision(:item_id) select content_item__set_live_revision(:revision_id, 'live'); update acs_objects set last_modified = current_timestamp, modifying_user = :user_id, modifying_ip = :peeraddr where object_id = :item_id