Re: ALTER TABLE lock level

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