I find this pair of queries useful; they show which constraints exist and which triggers belong to each. We need to make the constraints and triggers match after a detach right as things would be if the just-detached partition were an individual table having the same foreign key.
I don't find the useful queries in your last email. Can you provide them.
