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>)
Список pgsql-committers
Дерево обсуждения 

--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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Core support for "extensions", which are packages of SQL objects
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Suppress some compiler warnings in recent commits.