Cody Cutrer wrote:
> 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?
Not for 9.3. There are some related discussions, but at the earliest it
will happen for 9.4.
> Also, is a similar feature planned (for 9.3 or further out) for NOT
> NULL column constraints?
There are some discussions and patch about this, but it's not complete
yet. It might happen for 9.4.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services