"Stephan Szabo" <sszabo(at)kick(dot)com> writes:
>> If we had ALTER TABLE ADD CONSTRAINT then the problem would be largely
>> solved, I believe. This should be a minor exercise --- the heavy
>> lifting is already done, because heap.c's AddRelationRawConstraints()
>> is already set up to be invokable on a pre-existing relation.
> Does the AddRelationRawConstraints() check that the constraint is
> satisified as well when you add it? It didn't look like it did, but I
> could be missing something.
Oh, you're right, it does not. So you'd first have to run through the
table and verify that the constraint holds for each existing tuple.
Doesn't seem like a big deal though...
regards, tom lane