> > Or maybe I should insist that a matching constraint name be present > > *and* that the source text match? That's more of a pain to code though. > > That could also break some partitioning schemes; I don't > think it's a given that parents and children have matching > constraints, and afaik a parent can have constraints that a > child doesn't.
Yea, but that is why we would have parent ONLY constraints, they would only apply when the tuple is actually stored in the parent relation. In the typical partitioning case it does not really matter since the parent ONLY is typically empty. Andreas ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org