| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Cody Cutrer <cody(at)instructure(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: NOT VALID FKs and Constraints |
| Date: | 2013-01-25 14:31:18 |
| Message-ID: | 20130125143117.GA5584@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francois Tigeot | 2013-01-25 14:38:35 | Re: SYSV shared memory vs mmap performance |
| Previous Message | Bruce Momjian | 2013-01-25 13:53:12 | Re: SYSV shared memory vs mmap performance |