Postgres Pro
Downloads
Home   >   mailing lists

Re: forcing a table (parent in inheritance) tor emain empty - Mailing list pgsql-general

From Julien Rouhaud
Subject Re: forcing a table (parent in inheritance) tor emain empty
Date
Msg-id 2473c49d-567f-b71c-53c5-78289345af58@dalibo.com
Whole thread Raw
In response to Re: forcing a table (parent in inheritance) tor emain empty  (Rémi Cura <remi.cura@gmail.com>)
Responses Re: forcing a table (parent in inheritance) tor emain empty  (Rémi Cura <remi.cura@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Rémi Cura
Date:
Subject: Re: forcing a table (parent in inheritance) tor emain empty
Next
From: Rémi Cura
Date:
Subject: Re: forcing a table (parent in inheritance) tor emain empty