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

Perfect ! Cheers, Rémi C 2016-10-11 19:12 GMT+02:00 Julien Rouhaud : > 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

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

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 > *

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

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 thanks anyway for

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

On Tue, Oct 11, 2016 at 12:27 PM, Rémi Cura wrote: > Hey dear list, > I can't find a nice solution to enforce a necessary behaviour in my case : > I want a parent table to remain empty. > > Of course I could define a trigger and return NULL in any case, but I'd like > a more

[GENERAL] forcing a table (parent in inheritance) tor emain empty

Hey dear list, I can't find a nice solution to enforce a necessary behaviour in my case : I want a parent table to remain empty. Of course I could define a trigger and return NULL in any case, but I'd like a more elegant approach using check or constraints. Any thought appreciated, Cheers, Rémi