Hi Dan,
I was able to pinpoint the problem. It seems that
insert into cr_revisionsi (item_id, title, text) ... blah
works. But
insert into cr_fooi (item_id, title, text) ... blah will fail
you will need
insert into cr_fooi (item_id, revision_id, title, text)
Do you think we modify content_type__trigger_insert_statement to get the revision_id from content_type__refresh_trigger? That way we can do away with getting the "select acs_object_id_seq.nextval from dual;". Is this thought correct way to do it?
OT: When doing a content_item__new we are supposed to inherit from content_revision or content_item? Content_revision right?