On Tue, 2011-02-08 at 22:58 +0100, Bernd Helmle wrote: > > --On 8. Februar 2011 12:24:11 +0000 Simon Riggs <si...@2ndquadrant.com> > wrote: > > > Extend ALTER TABLE to allow Foreign Keys to be added without initial > > validation. FK constraints that are marked NOT VALID may later be > > VALIDATED, which uses an ShareUpdateExclusiveLock on constraint table and > > RowShareLock on referenced table. Significantly reduces lock strength and > > duration when adding FKs. New state visible from psql. > > Hi Simon, > > It seems this commit misses updates to system catalogs documentation > regarding pg_constraint.conisvalidated.
So it does. Thanks I will rectify. -- Simon Riggs http://www.2ndQuadrant.com/books/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers