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

Поиск
Список
Период
Сортировка
Искать
От
Bernd Helmle
Тема
Re: pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini
Дата
Msg-id
6A719D1DE382A36D92E56C7A@amenophis
Ответ на
Список
Дерево обсуждения
pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini Simon Riggs <simon@2ndQuadrant.com>
Re: pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini Bernd Helmle <mailings@oopsware.de>


--On 8. Februar 2011 12:24:11 +0000 Simon Riggs  
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 по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ