Thread: Re: [COMMITTERS] pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini


--On 8. Februar 2011 12:24:11 +0000 Simon Riggs <simon@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.

        Bernd

On Tue, 2011-02-08 at 22:58 +0100, Bernd Helmle wrote:
> 
> --On 8. Februar 2011 12:24:11 +0000 Simon Riggs <simon@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