Hi,
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.
Seems to affect all versions >= 9.1.
Regards,
Marko Tiikkaja