Where did I say that they never do that? It's just an observation based on experience (two decades in different companies of all sizes btw.) about the most bla

Where did I say that they never do that? It's just an observation based on experience (two decades in different companies of all sizes btw.) about the most blatant cases of this kind: the constraint was just set based on that rule of thumb, and since it was there in the schema, it was taken as gospel and any code throughout all the layers written with it in mind and shortcuts taken accordingly, all while there never was any requirement for it nor was the uniqueness actually assured (cf. those posts about names) and the breaking only a matter of time. Mabye I've become jaded, but I've come to see those as being among the most annoying and unnecessarily time-consuming classes of issues.