postgresql7.1 update cr_revisions set publish_date = now() where revision_id = :latest_revision_id update acs_objects set modifying_user = :user_id, last_modified = now() where object_id = :latest_revision_id