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

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini
Date: 2011-02-08 21:58:38
Message-ID: 6A719D1DE382A36D92E56C7A@amenophis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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

Bernd

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2011-02-08 22:03:14 Re: Extensions support for pg_dump, patch v27
Previous Message Tom Lane 2011-02-08 21:54:45 Re: Extensions versus pg_upgrade

Browse pgsql-committers by date

  From Date Subject
Next Message Simon Riggs 2011-02-08 23:00:03 Re: [COMMITTERS] pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini
Previous Message Tom Lane 2011-02-08 21:23:01 pgsql: Core support for "extensions", which are packages of SQL objects