Re: [PATCHES] Inherited Constraints - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: [PATCHES] Inherited Constraints
Date
Msg-id 1141681997.3810.4.camel@localhost.localdomain
Whole thread Raw
In response to Re: [PATCHES] Inherited Constraints  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [PATCHES] Inherited Constraints
List pgsql-hackers
Ühel kenal päeval, E, 2006-03-06 kell 12:12, kirjutas Bruce Momjian:
> Added to TODO:
> 
>       o Prevent parent tables from altering or dropping constraints
>         like CHECK that are inherited by child tables
> 
>         Dropping constraints should only be possible with CASCADE.
> 
> and we already have this in TODO:
> 
>         o %Prevent child tables from altering or dropping constraints
>           like CHECK that were inherited from the parent table
> 
> so I think we now have all the failure cases documented.

If you want to be consistent, then ALTER TABLE ONLY ADD CONSTRAINT  .. 
should also be forbidden, so you can't create non-inherited constraints

---------------
Hannu




pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: [PATCHES] LDAP auth
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Inherited Constraints