| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Bernd Helmle <mailings(at)oopsware(dot)de> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [COMMITTERS] pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini |
| Date: | 2011-02-08 23:00:03 |
| Message-ID: | 1297206003.1770.9113.camel@ebony |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
On Tue, 2011-02-08 at 22:58 +0100, Bernd Helmle wrote:
>
> --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.
So it does. Thanks I will rectify.
--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training and Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-02-08 23:12:58 | pgsql: Suppress some compiler warnings in recent commits. |
| Previous Message | Bernd Helmle | 2011-02-08 21:58:38 | Re: pgsql: Extend ALTER TABLE to allow Foreign Keys to be added without ini |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-02-08 23:54:38 | Re: Extensions versus pg_upgrade |
| Previous Message | Bruce Momjian | 2011-02-08 22:42:12 | Re: btree_gist (was: CommitFest progress - or lack thereof) |