On 5/27/13 5:23 PM, I wrote:
> Today I got (unfortunately) reminded that this statement, in
> sql-altertable.html under VALIDATE CONSTRAINT, is not true anymore:
>
> The value of separating validation from initial creation of the
> constraint is that validation requires a lesser lock on the table than
> constraint creation does.
Since nobody seems to want to pick this up, I'm going to suggest the
following wording:
The value of separating validation from initial creation of the
constraint is that you can immediately start enforcing the
constraint on all future rows, but delay the validation of
pre-existing data until your database is not under heavy load.
But I'm not going to object to simply removing the entire sentence.
Regards,
Marko Tiikkaja