NOT VALID FKs and Constraints

From: Cody Cutrer <cody(at)instructure(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: NOT VALID FKs and Constraints
Date: 2013-01-24 18:11:45
Message-ID: CA+=qeWs_xtLOu5xg6nT=67YmkFjtAQ_98tFs0vUob-hRU+4Quw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

9.1 introduced delayed validation on FKs, and 9.2 on table constraints,
however neither one has been useful due to lesser-locks on ALTER TABLE
being reverted (see
http://www.postgresql.org/message-id/1330350691-sup-1@alvh.no-ip.org),
preventing the lock benefits during the VALIDATE stage.

I don't see any commits since then about either one. Is fixing this still
on the radar for 9.3? Also, is a similar feature planned (for 9.3 or
further out) for NOT NULL column constraints?

Thanks,

Cody Cutrer

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2013-01-24 18:12:47 Re: [PATCH] pg_isready (was: [WIP] pg_ping utility)
Previous Message Noah Misch 2013-01-24 18:09:28 Re: Materialized views WIP patch