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
Дата: