postgresql7.1 select content_item__new( varchar :name, null, null, null, now(), null, null, :creation_ip, 'content_item', 'content_revision', null, null, 'text/plain', null, null ) select acs_rel__new ( null, 'user_portrait_rel', :user_id, :item_id, null, null, null ) declare v_revision_id integer; begin v_revision_id := content_revision__new( :title, :portrait_comment, now(), :guessed_file_type, null, null, :item_id, null, now(), :user_id, :creation_ip, :n_bytes); update cr_items set live_revision = v_revision_id where item_id = :item_id; return v_revision_id; end; update cr_revisions set lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]] where revision_id = :revision_id update cr_revisions set description = :portrait_comment, publish_date = now(), mime_type = :guessed_file_type, content_length = :n_bytes, title = :title where revision_id = :revision_id