Relational view insert/update triggers on resource instances views don't update graph publication id #12496
Description
In 8.0.x, when inserting/updating resource instance views generated by the relational view functions, incoming graph publication ids are not implemented so the column in the resource_instances table gets set to null. We should update the trigger functions here to ensure that this value is set by the incoming id. Additionally, as a convenience we should set this to the latest graph publication id when incoming value is null. This is likely an opportunity for us to centralize the logic to get the latest graph publication id into a function, but we should keep in mind performance here as these triggers get called for each record being inserted.