When you do the following:
v_item_id := content_item__new(...)
a row is inserted into acs_object_context_index via a trigger. Then later in the same transaction/function you do:
update acs_objects set security_inherit_p = 'f'
where object_id = v_item_id;
which results in the same row in acs_object_context_index to be updated by a trigger - causing a data-change violation. The only work-around that I see for this is to overload content_item__new and acs_objects__new so that the item can be created with security_inherits_p set to false. If you want, you can make those changes and send me a patch. If not, I'll try and do it tonight.
