"Andrew Dunstan" <andrew@dunslane.net> writes:
>> I object to creating gratuitous incompatibilities with the SQL standard,
>> which will obstruct legitimate features down the road. The SQL standard
>> says it is <schema>.<constraint>.
> Is there a case for enforcing uniqueness on constraint names, then?
Other than "SQL92 says so"? Very little. This seems to me to be a
design error in the spec. Per-table constraint names are easier to
work with --- if they're global across a schema then you have a serious
problem avoiding collisions.
The spec does have a notion of "assertions", which are constraints not
tied to any specific table; for those I suppose you need a
schema-wide namespace. I do not foresee us supporting such things
anytime soon though.
regards, tom lane
