> While I agree in principle that such a thing should be > able to be done, it simply isn't possible. (in PostgreSQL, you can't > even add an index to a view, which a unique constraint would depend > on).
Agreed on that.
But such an extension would require a view to be more than just SELECT.