Re: creating CHECK constraints as NOT VALID
| От | Jaime Casanova |
|---|---|
| Тема | Re: creating CHECK constraints as NOT VALID |
| Дата | |
| Msg-id | BANLkTimmq2CBrgwteTzO8i4uem40oUrvZw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: creating CHECK constraints as NOT VALID (Alvaro Herrera <alvherre@commandprompt.com>) |
| Ответы |
Re: creating CHECK constraints as NOT VALID
|
| Список | pgsql-hackers |
On Tue, Jun 14, 2011 at 4:14 PM, Alvaro Herrera <alvherre@commandprompt.com> wrote: > Excerpts from Alvaro Herrera's message of lun jun 13 18:08:12 -0400 2011: >> Excerpts from Dean Rasheed's message of sáb jun 11 09:32:15 -0400 2011: > >> > I think that you also need to update the constraint exclusion code >> > (get_relation_constraints() or nearby), otherwise the planner might >> > exclude a relation on the basis of a CHECK constraint that is not >> > currently VALID. >> >> Ouch, yeah, thanks for pointing that out. Fortunately the patch to fix >> this is quite simple. I don't have it handy right now but I'll post it >> soon. > > Here's the complete patch. > this doesn't apply -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación
В списке pgsql-hackers по дате отправления: