postgresql7.1 select acs_object_id_seq.nextval update cr_revisions set mime_type = :mime_type, lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]] where revision_id = :revision_id update cr_revisions set content_length = lob_length(lob) where revision_id = :revision_id select content_item__new ( varchar :name, NULL, NULL, NULL, current_timestamp, :user_id, :term_item_id, :peeraddr, 'content_item', 'image', NULL, NULL, NULL, NULL, NULL ); select content_revision__new( :title, :description, current_timestamp, NULL, NULL, NULL, :new_item_id, NULL, current_timestamp, :user_id, :peeraddr ); update cr_revisions set mime_type = :mime_type, lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]] where revision_id = :new_revision_id update cr_revisions set content_length = lob_length(lob) where revision_id = :new_revision_id select acs_object__new( NULL, 'cr_item_child_rel', current_timestamp, NULL, NULL, :term_item_id );