Re: forcing a table (parent in inheritance) tor emain empty

Поиск
Список
Период
Сортировка
От Rémi Cura
Тема Re: forcing a table (parent in inheritance) tor emain empty
Дата
Msg-id CAJvUf_vvgjQpF5ak_THOjACLs2mqmNtVbeWxH1pY9wbUUuTznA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: forcing a table (parent in inheritance) tor emain empty  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
Список pgsql-general
Дерево обсуждения
Perfect !

Cheers,
Rémi C

2016-10-11 19:12 GMT+02:00 Julien Rouhaud <julien.rouhaud@dalibo.com>:
On 11/10/2016 19:04, Rémi Cura wrote:
> This solution is very nice.
> Sadly the check is inherited by the children
> (I only want the parent to be empty, not the children).
>
> It seems the element that are not inherited are
>
>   * Indexes
>   * Unique constraints
>   * Primary Keys
>   * Foreign keys
>   * Rules and Triggers
>

you can specify a "NO INHERIT" on the check constraint, that should
solve your issue.

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org

В списке pgsql-general по дате отправления:

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: forcing a table (parent in inheritance) tor emain empty
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)