Re: Check constraints on partition parents only?
| От | Nikhil Sontakke |
|---|---|
| Тема | Re: Check constraints on partition parents only? |
| Дата | |
| Msg-id | CABamaqP_b49vPUeJ4oSsB7-pT2N=qmhxLNFFF+k+V7zo21X3Nw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Check constraints on partition parents only? (Alvaro Herrera <alvherre@commandprompt.com>) |
| Ответы |
Re: Check constraints on partition parents only?
|
| Список | pgsql-hackers |
> 8.4 had this change:
>
> *
> Force child tables to inherit CHECK constraints from parents
> (Alex Hunsaker, Nikhil Sontakke, Tom)> You're not the only one who occasionally bangs his head against it.
Sorry for the occasional head bumps :)
Yeah. I think it's good that there's a barrier to blindly dropping a
constraint that may be important to have on children, but there should
be a way to override that.
Hmmm, but then it does open up the possibility of naive users shooting themselves in the foot. It can be easy to conjure up a parent-only-constraint that does not gel too well with its children. And that's precisely why this feature was added in the first place..
Regards,
Nikhils
В списке pgsql-hackers по дате отправления: