postgresql7.1
select acs_object_id_seq.nextval
select content_revision__new (
:new_title, -- title =>
:new_desc, -- description
current_timestamp, -- publish_date
null, -- mime_type
null, -- nls_language
null, -- locale
:photo_id, -- item_id
:revision_id, -- revision_id
current_timestamp, -- creation_date
:user_id, -- creation_user
:peeraddr -- creation_ip
)
select content_item__set_live_revision (:revision_id)