Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini - Mailing list pgsql-committers

From Bernd Helmle
Subject Re: pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini
Date
Msg-id 6A719D1DE382A36D92E56C7A@amenophis
Whole thread Raw
In response to pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-committers
Tree view 

--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

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Core support for "extensions", which are packages of SQL objects
Next
From: Tom Lane
Date:
Subject: pgsql: Suppress some compiler warnings in recent commits.