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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
