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

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Bernd Helmle <mailings(at)oopsware(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini
Date: 2011-02-08 23:00:03
Message-ID: 1297206003.1770.9113.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2011-02-08 23:12:58 pgsql: Suppress some compiler warnings in recent commits.
Previous Message Bernd Helmle 2011-02-08 21:58:38 Re: pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-02-08 23:54:38 Re: Extensions versus pg_upgrade
Previous Message Bruce Momjian 2011-02-08 22:42:12 Re: btree_gist (was: CommitFest progress - or lack thereof)